Opening a form at the correct record

[Kate]

I have a form (form1) that has a button (View Details) to open another form
(form2), which has the details relating to each record in form1. All the
information is stored in one table.

My problem is, how do I get the correct details for a given record.

For example, I look at record 5 and press the View Details button for that
record and would expect to see the Details for record 5. I however get
#NAME. I'm obviously not referencing correctly.

I've tried putting the Details into a separate table, this also has failed.

Can anyone help?!!

TIA
Kate

 

[Dan Artuso]

Hi,
The usual way is to use the Where condition argument of the
OpenForm method, using the primary key of the record you're
viewing as criteria. You don't say how you're trying to accomplish this
so I don't know if you are using this method or not.

In any case, check out the OpenForm method in Help.