Combo affects several subforms

[auujxa2 via AccessMonster.com]

I have a bound form, which selects the record I want by a combo box using:

Private Sub cboSite_AfterUpdate()
Me.RecordsetClone.FindFirst "[Location:] = " & Me.cboSite
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

I have several subforms, all with the "[Location:]" field in it's respective
table as my primary key.

How can I have all the subforms link to the main combo? (me.cboSite)?

Thank you SO MUCH in advance.

 

[Jeanette Cunningham]

Hi auujxa2 ,
yes, you do this using the LinkMasterFields and LinkChildFields.

Select a subform in design view, open the property dialog, on the data, set
the 2 fields I mentioned above to the field Location.
Location would be the primary key in the table for the main form and it
would be a foreign key in the table for the subform.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

Type correction

Hi auujxa2 ,
yes, you do this using the LinkMasterFields and LinkChildFields.

Select a subform in design view, open the property dialog, on the data
*tab*, set
the 2 fields I mentioned above to the field Location.
Location would be the primary key in the table for the main form and it
would be a foreign key in the table for the subform.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hi auujxa2 ,
yes, you do this using the LinkMasterFields and LinkChildFields.

Select a subform in design view, open the property dialog, on the data,
set the 2 fields I mentioned above to the field Location.
Location would be the primary key in the table for the main form and it
would be a foreign key in the table for the subform.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I have a bound form, which selects the record I want by a combo box using:

Private Sub cboSite_AfterUpdate()
Me.RecordsetClone.FindFirst "[Location:] = " & Me.cboSite
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

I have several subforms, all with the "[Location:]" field in it's
respective
table as my primary key.

How can I have all the subforms link to the main combo? (me.cboSite)?

Thank you SO MUCH in advance.