pwhite1048
Technical User
I have a form on which I want to double-click a value in a field on the form and open a different form and show the matching 'record'.
Form1 contains an ID field where I've placed an On Dbl Click macro to OpenForm, Form name is Form2, Where is [Forms]![Form2]![ID]=[Forms]![Form1]![ID]. When I double-click the ID in Form1, it opens a filtered Form2, but it's a blank form (Record 1 of 1 - filtered - all ready for data entry). I don't want that record, I want the one where the IDs match. Does it make a difference that on Form1, the ID field is an AutoNumber and is unique?
I also tried Where [Forms]![Form1]![ID], but that gets me the first record in Form2, filtered but with all records in the filtering.
I played around with some other methods, and got one where it would come up and ask for the ID, and if I typed it, it would open that record, but I want it to do it automatically.
All help appreciated....
Trish
Form1 contains an ID field where I've placed an On Dbl Click macro to OpenForm, Form name is Form2, Where is [Forms]![Form2]![ID]=[Forms]![Form1]![ID]. When I double-click the ID in Form1, it opens a filtered Form2, but it's a blank form (Record 1 of 1 - filtered - all ready for data entry). I don't want that record, I want the one where the IDs match. Does it make a difference that on Form1, the ID field is an AutoNumber and is unique?
I also tried Where [Forms]![Form1]![ID], but that gets me the first record in Form2, filtered but with all records in the filtering.
I played around with some other methods, and got one where it would come up and ask for the ID, and if I typed it, it would open that record, but I want it to do it automatically.
All help appreciated....
Trish