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,

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" <lixiaof (AT) yahoo (DOT) com> wrote