Hello Amy.

"dirtrhoads" (Amy) wrote:
I have set up an OpenForm macro on a double click event in a subform.
The subform is titled Active Orders at Belmont Subform. The form I
have set to open is Order Details. I have set up the macro to open
Order Details when I click on the PO_Number from my subform and it
opens perfect, however, I want it to open up to the record I double
clicked. As of right now, it is opening up to the first record.
I tried typing in PO_Number in the WHERE clause but this caused the
event to open up to a New Record...

The WHERE clause sould have the form "PO_Number = 123". Since the number
depends on a field of the current record, this WHERE clause has to be
calculated. Try something like this in the argument:
="PO_Number = " & [PO_Number]

--
Regards,
Wolfgang