Linking 2 subforms within a main form

[snorf3]

I'm trying to create an input page for doctors in a clinic. The main form contains patient information (name, ID, address, etc).

I then have a tab control for 2 subforms...that is one subform on each tab page. One is "Clinical" and the other is "Billing". Both subforms are linked to the main form using the patient ID number.

My problem is I want the two subforms linked to each other. They both contain the fields "Visit_No" and "Time_of_visit", with the the visit number as autonumber and time of visit set to default Now (). So, how can I get both subforms to have identical "Visit_No" and "Time_of_visit" entries when adding a new record? The main form does not have these two fields.


[This message has been edited by snorf3 (edited 06-07-2001).]

 

[D-Fresh]

Can you use unbound hidden controls for these fields on the main form then link them along with the ID to each subform? That's probably the easiest way..

Doug

 

[snorf3]

Thanks to both for your advice!

Pat,

Where am I supposed to insert that syntax? It doesn't work if I just put it into the "Link Child Fields" line of the subform properties sheet. And if I put it in both the "Link Child Fields" and the "Link Master Fields" lines it asks me for the parameter value. help!

 

[snorf3]

Nevermind! I put it into the default value of the object itself and that seems to work. Thanks again!