Currently I have the following scenario:

I am having a form, that should have a subform. The form has different 
buttons, depending what button the user clicks, an existing form should 
be loaded into the subform! Does anyone has an idea how to do that?
Thanx, for any help.

Cheers,
Karl

Karl

One way would be to have all the subforms loaded but only one (or none) 
visible on start-up.  When you click a button you can change the visibilty 
of the subforms.

Paul

> Currently I have the following scenario:

> I am having a form, that should have a subform. The form has different 
b> uttons, depending what button the user clicks, an existing form should 
b> e loaded into the subform! Does anyone has an idea how to do that?
T> hanx, for any help.

> Cheers,
K> arl

You can just change the Source Object on your subform depending on your 
needs.  For example:

           Select Case Me!QNum
                Case 8
                    [Forms]![frmAnswers]![frmMultiAnswer].SourceObject =3D 
"frmQ08"
                    [Forms]![frmAnswers]![frmMultiAnswer].Visible =3D True
                    [Forms]![frmAnswers]![frmMultiAnswer].LinkMasterFields 
=3D "Snum;Qnum"
                    [Forms]![frmAnswers]![frmMultiAnswer].LinkChildFields 
=3D "Snum;Qnum"
                Case 14
                    [Forms]![frmAnswers]![frmMultiAnswer].SourceObject =3D 
"frmQ14"
                    [Forms]![frmAnswers]![frmMultiAnswer].Visible =3D True
                    [Forms]![frmAnswers]![frmMultiAnswer].LinkMasterFields 
=3D "Snum;Qnum"
                    [Forms]![frmAnswers]![frmMultiAnswer].LinkChildFields 
=3D "Snum;Qnum"
               Case etc....
               Case etc....
               Case etc....
               Case etc....
               Case Else
          End Select

Hope that helps...

____________________________________________________

John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________

The doors we open and close each day decide the lives we live
____________________________________________________

CONFIDENTIALITY & PRIVILEGE NOTICE
The information contained in this email message is intended for the named 
addressee only.  If you are not the intended recipient you must not copy, 
distribute, take any action reliant on, or disclose any details of the 
information in this email to any other person or organisation.  If you 
have received this email in error please notify us immediately.

>>> karl@l... 27/05/2002 19:09:53 >>>
Currently I have the following scenario:

I am having a form, that should have a subform. The form has different
buttons, depending what button the user clicks, an existing form should
be loaded into the subform! Does anyone has an idea how to do that?
Thanx, for any help.

Cheers,
Karl

This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient,
please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily
the views of Hunter Health.