Subform Data Filter

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

Guest

I have a form created with three control buttons that open the subforms in
different windows. However when I am looking at a specific record when I
open the subform it doesn't stay with the same record but rather opens the
first record. How do I ensure that when the control button is pushed that it
opens the related form on the same record.
 
The most common use of a subform is to display the "many" side of a
one-to-many relationship, such as the Orders of a particular Customer. In
this most common implementation, the main form stays "in sync" with its
subform(s) by a common field, specified in the subform's Link Master Fields
and Link Child Fields properties. In this case, it would be the CustomerID.

So, for each subform, set these properties to the name of the field in the
main form's RecordSource and its corresponding field in the RecordSource of
the subform.

Hope that helps.
Sprinks
 
Back
Top