open a subform

[Rich]

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

[Bradley]

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

[Jeremy B. Shapiro]

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

[Rich]

"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