By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,631 Members | 892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,631 IT Pros & Developers. It's quick & easy.

Setting recordsource - subform within subform

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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.
Nov 12 '05 #2

P: n/a
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.


Nov 12 '05 #3

P: n/a
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.

Nov 12 '05 #4

P: n/a
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.
Nov 12 '05 #5

P: n/a

"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
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.