Link Two Subforms to Each Other

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two subforms sitting on a form (on a tab control). I want to link the
two subforms so that if they change to another record on the top subform, it
goes to the record in the bottom subform. The main form is not bound to any
table. It is just be used to hold the tab control.

Any suggestions?

Thanks!
 
I don't understand what you mean. I tried putting a textbox on the main form
and child/master linking to the first subform but it comes up with an error
that it cannot link unbound fields.

Also, I can't link the main form to a specific table because each tab in the
tab control is looking at a separate table.

Debra Ann
 
Yes. The first subform is coming directly from the table and is set up in a
single form view. The second subform is looking at a query of the same table.
 
OK,
On a one subform effects the other. So on the formdesign for the main
subform. You would need to control the other subform.
subfomr1;
on next or
rownumber.controlname.value
'if its a datasheet rowhieght=1 then get the controlname.value
'if its a form then nextrecord using a cotrol name
forms!subform2.filter=""
forms!subform2.filteron=true

The subform2 has to be opened
Reference the subforms form within each other.
 
Back
Top