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]

On 24 Nov 2003 09:14:37 -0800 in comp.databases.ms-access,
ma**********@hotmail.com (Ellen Manning) wrote:

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.

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

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

[Jim Allensworth]

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

- Jim

On 24 Nov 2003 09:14:37 -0800, ma**********@hotmail.com (Ellen
Manning) wrote:

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.

[Ellen Manning]

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


"Jim Allensworth" <ji****@Notdatacentricsolutions.com> wrote in message news:<3f****************@news.west.earthlink.net>. ..

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

- Jim

On 24 Nov 2003 09:14:37 -0800, ma**********@hotmail.com (Ellen
Manning) wrote:

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]

On 25 Nov 2003 06:16:38 -0800 in comp.databases.ms-access,
ma**********@hotmail.com (Ellen Manning) wrote:

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

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]

"Trevor Best" <bouncer@localhost> wrote in message
news:mq********************************@4ax.com...

On 25 Nov 2003 06:16:38 -0800 in comp.databases.ms-access,
ma**********@hotmail.com (Ellen Manning) wrote:

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

posted...naturally.
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 :-)

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