Setting recordsource - subform within subform

[Ellen Manning]

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]

Re: Setting recordsource - subform within subform

On 24 Nov 2003 09:14:37 -0800 in comp.databases. ms-access,
manning_news@ho tmail.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![MySubFormsSubfo rm].Form.Recordsou rce="..."

--
A)bort, R)etry, I)nfluence with large hammer.

[Jim Allensworth]

Re: Setting recordsource - subform within subform

Try this...
Me.subFormContr olName.Form.Rec ordSource

- Jim

On 24 Nov 2003 09:14:37 -0800, manning_news@ho tmail.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]

Re: Setting recordsource - subform within subform

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




"Jim Allensworth" <jimNOT@Notdata centricsolution s.com> wrote in message news:<3fc25cad. 613582421@news. west.earthlink. net>...[color=blue]
> Try this...
> Me.subFormContr olName.Form.Rec ordSource
>
> - Jim
>
> On 24 Nov 2003 09:14:37 -0800, manning_news@ho tmail.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]

Re: Setting recordsource - subform within subform

On 25 Nov 2003 06:16:38 -0800 in comp.databases. ms-access,
manning_news@ho tmail.com (Ellen Manning) wrote:
[color=blue]
>Thanks for your replies. I figured out the answer right after I posted...natura lly.[/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]

Re: Setting recordsource - subform within subform


"Trevor Best" <bouncer@localh ost> wrote in message
news:mq97svska4 4h8n8q9r40nfje0 7c0m8gdsm@4ax.c om...[color=blue]
> On 25 Nov 2003 06:16:38 -0800 in comp.databases. ms-access,
> manning_news@ho tmail.com (Ellen Manning) wrote:
>[color=green]
> >Thanks for your replies. I figured out the answer right after I[/color][/color]
posted...natura lly.[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