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...

Can you please let me know what I need to do in order to have this open up
to the selected record?

Thank you,
Amy