Connecting Tech Pros Worldwide Forums | Help | Site Map

Setting recordsource - subform within subform

Ellen Manning
Guest
 
Posts: n/a
#1: Nov 12 '05
Using A2K. I need the syntax to set the recordsource for a subform
within a subform.

The "main" subform's recordsource changes based on user input. I need
to change the recordsource on the subform within that.

What is the correct syntax?

Thanks.

Trevor Best
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Setting recordsource - subform within subform


On 24 Nov 2003 09:14:37 -0800 in comp.databases.ms-access,
manning_news@hotmail.com (Ellen Manning) wrote:
[color=blue]
>Using A2K. I need the syntax to set the recordsource for a subform
>within a subform.
>
>The "main" subform's recordsource changes based on user input. I need
>to change the recordsource on the subform within that.
>
>What is the correct syntax?
>
>Thanks.[/color]

me![MySubform].Form![MySubFormsSubform].Form.Recordsource="..."

--
A)bort, R)etry, I)nfluence with large hammer.
Jim Allensworth
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Setting recordsource - subform within subform


Try this...
Me.subFormControlName.Form.RecordSource

- Jim

On 24 Nov 2003 09:14:37 -0800, manning_news@hotmail.com (Ellen
Manning) wrote:
[color=blue]
>Using A2K. I need the syntax to set the recordsource for a subform
>within a subform.
>
>The "main" subform's recordsource changes based on user input. I need
>to change the recordsource on the subform within that.
>
>What is the correct syntax?
>
>Thanks.[/color]

Ellen Manning
Guest
 
Posts: n/a
#4: Nov 12 '05

re: Setting recordsource - subform within subform


Thanks for your replies. I figured out the answer right after I posted...naturally.




"Jim Allensworth" <jimNOT@Notdatacentricsolutions.com> wrote in message news:<3fc25cad.613582421@news.west.earthlink.net>. ..[color=blue]
> Try this...
> Me.subFormControlName.Form.RecordSource
>
> - Jim
>
> On 24 Nov 2003 09:14:37 -0800, manning_news@hotmail.com (Ellen
> Manning) wrote:
>[color=green]
> >Using A2K. I need the syntax to set the recordsource for a subform
> >within a subform.
> >
> >The "main" subform's recordsource changes based on user input. I need
> >to change the recordsource on the subform within that.
> >
> >What is the correct syntax?
> >
> >Thanks.[/color][/color]
Trevor Best
Guest
 
Posts: n/a
#5: Nov 12 '05

re: Setting recordsource - subform within subform


On 25 Nov 2003 06:16:38 -0800 in comp.databases.ms-access,
manning_news@hotmail.com (Ellen Manning) wrote:
[color=blue]
>Thanks for your replies. I figured out the answer right after I posted...naturally.[/color]

There's a bloke at work who usually asks me questions then figures out
the answer without me saying a word. I wish I could make a living out
of that. I'm thinking of leaving him a cardboard cutout of myself for
when I'm not in the office :-)

--
A)bort, R)etry, I)nfluence with large hammer.
Nick Marshall
Guest
 
Posts: n/a
#6: Nov 12 '05

re: Setting recordsource - subform within subform



"Trevor Best" <bouncer@localhost> wrote in message
news:mq97svska44h8n8q9r40nfje07c0m8gdsm@4ax.com...[color=blue]
> On 25 Nov 2003 06:16:38 -0800 in comp.databases.ms-access,
> manning_news@hotmail.com (Ellen Manning) wrote:
>[color=green]
> >Thanks for your replies. I figured out the answer right after I[/color][/color]
posted...naturally.[color=blue]
>
> There's a bloke at work who usually asks me questions then figures out
> the answer without me saying a word. I wish I could make a living out
> of that. I'm thinking of leaving him a cardboard cutout of myself for
> when I'm not in the office :-)
>[/color]

That is a well-known programmer's tip - explain your problem (coding wise,
naturally!!) to someone else. By getting your thoughts (hopefully!) in
order, your subconscious very often works out the answer. I am not a
psychiatrist, but I do know that this works - and has done for years.
Of course if you cannot explain your problem to someone else (because you
cannot get your thoughts in order...) then ...

If frustrates me - while we are on the subject - that I know that things are
possible, indeed often we can see them being done. But trying to replicate
them... ;)}

Nick


Closed Thread