From: Endo on
PO number
"Endo" <3zc7s7(a)bma.biglobe.ne.jp> wrote in message news:...
>
> "dirtrhoads" <dirtrhoads(a)discussions.microsoft.com> wrote in message
> news:FE05F4CB-006D-4891-BA95-0FA20E875115(a)microsoft.com...
>>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
>