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

open a subform

P: n/a
In a main form, I want to open a subform at one condition and open a
different subform at another condition, How to it? I'm using MS-access
2000.
Your help is highly appreciated.

Rich
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Rich wrote:
In a main form, I want to open a subform at one condition and open a
different subform at another condition, How to it? I'm using MS-access
2000.
Your help is highly appreciated.

Rich


Change the Source Object

Me![subMySubform].SourceObject = "frmMyForm"
--
regards,

Bradley

Nov 13 '05 #2

P: n/a
Rich,

Depending on the complexity and the frequency of the sub-form changing, you
could change the visibility property of the subforms using the On Current
event for the form if you want it to change when you change records and for
the On Change event for the control that determines which subform should be
shown.

--
Jeremy Shapiro
Asandia, Corp.
www.asandia.com
1.866.ASANDIA (272.6342)

"Rich" <li*****@yahoo.com> wrote in message
news:1c**************************@posting.google.c om...
In a main form, I want to open a subform at one condition and open a
different subform at another condition, How to it? I'm using MS-access
2000.
Your help is highly appreciated.

Rich

Nov 13 '05 #3

P: n/a
"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message news:<40**********@news.melbourne.pipenetworks.com >...
Rich wrote:
In a main form, I want to open a subform at one condition and open a
different subform at another condition, How to it? I'm using MS-access
2000.
Your help is highly appreciated.

Rich


Change the Source Object

Me![subMySubform].SourceObject = "frmMyForm"


It works!
Thank you very much.

Rich
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.