Help...linking forms using command button

[nyrob609]

Can any one help!...I have several tables. I have a main table with patient information, second table is for appointments, third table for insurance information, etc.....

I create Main Form to enter data for table one with Patient ID # as my key and auto number and I inserted subforms for the Insurance information and Appointments in the Main form. Each time I create record it copies the same Patient ID # to the subforms keeping everything together...which is great.

The form and subforms take most of the screen so I decided to put command buttons to open the other forms but what is not doing is creating a copy of Patient ID # table one as did for the other.

What am i doing wrong....do I have to create a Macro to copy the ID number on each new record I create on the other forms.

 

[pbaldy]

What I would do instead of opening a second form is to either organize your many subforms onto a tab control, so users only see the subform on the specific tab they've chosen, or use one subform control and change what subform goes into it.

 

[nyrob609]

Thank you for the info. How do I do the second option subform control...

 

[pbaldy]

Something along these lines (code in the main form):

Me.SubformControlName.SourceObject = "FormName"