Opening a subform to a chosen record

[Terri Watson]

I have a form in Access 97 with a full-page subform. The
form is based on a table with the key identifier
BloodID. The subform is based on a table linked in a
many-to-one relationship with the source table for the
form; it's key identifier is VialID.

I'd like to be able to open this form/subform, at a
chosen BloodID/VialID, with the subform at the chosen
VialID record. I can open the form to a chosen BloodID,
but the subform is on the first VialID for that BloodID.

Is there a way to do this?

Thanks - Terri
(e-mail address removed)

 

[HSalim]

yes you can. use DoCmd.GoToRecord
but how/where are you going to determine which record you want to go to?

 

[Terri]

I am opening this form from a command button on another
form, which lists the VialID records in a "spreadsheet"
format. I want the user to be able to select one of
these records, click the button, and view this second
form, opened on the VialID of the record the user
selected.

Thanks - Terri

 

[HSalim]

Terri,
Also see the post from Allen Browne which has more detailed info
- Message titled Open Subform to specific record dt 7/24/03

HS