Bookmarking a Subform

[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

 

[Van T. Dinh]

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.

 

[Guest]

It is not the primary key. I have to combine two fields to create a unique
record.

Thanks!

Dwight

 

[Van T. Dinh]

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

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