<de**********@gmail.comwrote in message
news:11**********************@t46g2000cwa.googlegr oups.com...
Hi everyone,
I have a form which has a subform. Now based on the user selection, I
want to replace this subform with another at run time.
One approach I tried was to have both the forms on the screen and have
one of the invisible and switch the visibility states when the user
makes a selection. However, if I make the topmost form invisible, the
underlying fom still does not show for some reason.
Anyone has any suggestions, I would be grateful.
You could have each subform on a TabControl page or you can use a single subform
control and change its SourceObject property to toggle between the two subforms.
With the latter you would have to be careful to also change the MasterLink and
ChildLink properties if the same entries won't apply to both subforms.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com