Goto a Specific Record

[Keith]

I have an inventory database which works great.

I set it up so when I view the software installed on a particular PC, if I
double click any item of software it opens a forum to view the details of
the software and filters the form so it only shows me the software for the
PC I was viewing.

This is what I want to happen, but I would really like to be able to have it
do all this plus goto the record in the software form that I double clicked
on in the inventory list.

I know how to goto first/last etc., but how can I goto a specific record? I
won't necessarily know the record number. Would be using an ID autonumber
field in the DB.

 

[Marshall Barton]

I have an inventory database which works great.

I set it up so when I view the software installed on a particular PC, if I
double click any item of software it opens a forum to view the details of
the software and filters the form so it only shows me the software for the
PC I was viewing.

This is what I want to happen, but I would really like to be able to have it
do all this plus goto the record in the software form that I double clicked
on in the inventory list.

I know how to goto first/last etc., but how can I goto a specific record? I
won't necessarily know the record number. Would be using an ID autonumber
field in the DB.

Instead of using the MoveFirst or MoveLast, try using
FindFirst.

If you have trouble figuring out how to do that, post back
with more details about how you are opening the details
form, the pertinate data fields fields and any related
controls.