Bookmarking a Subform

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

Guest

I have a main form that has a listbox on it, and a subform that displays a
lot of data. How can I get the subform to go to the record that is selected
in the listbox?

Thanks in advance!

Dwight
 
Are you using the LinkMasterFields and LinkChildFields Property of the
SubformControl?

If the bound Column of the ListBox is the PrimaryKey linking to the
ForeignKey of the Subform's RecordSource, you can simply use the
(single-select) ListBox as the LinkMasterFields.
 
It is not the primary key. I have to combine two fields to create a unique
record.

Thanks!

Dwight
 
You can specify 2-Field combination for the LinkMasterFields /
LinkChildFields.

Check Access Help on how to specify 2 Fields in the LinkMasterFields /
LinkChildFields.
 
Back
Top