Multiple Subforms from one form

Hi everyone,
I have an access database which holds cases of infectious diseases. I
am currently modifyong some of the forms. I would like to know if it
is possible to change the subform which comes up according to the
selection of the user from a combobox in the parent form. For example
- if the case has chickenpox a certain subform would come up. If the
case has hepatitis a different subform would come up.
would appreciate any help,
regards
Gianfranco

Save the form with a subform control but nothing in it.

At runtime, assign the SourceObject property of the subform control, and set
the LinkMasterFields and LinkChildFields again.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Gianfranco Spiteri" wrote in message
om...
Hi everyone,
I have an access database which holds cases of infectious diseases. I
am currently modifyong some of the forms. I would like to know if it
is possible to change the subform which comes up according to the
selection of the user from a combobox in the parent form. For example
- if the case has chickenpox a certain subform would come up. If the
case has hepatitis a different subform would come up.
would appreciate any help,
regards
Gianfranco