G
Guest
I'm trying to create a macro to open a subform to the record that was
double-clicked.
I've got a macro set on the OnDblClick property as follows:
Action: OpenForm
Form Name: Reservations_subform
Where condition:
[Reservations]![ReservationID]=[Forms]!Reservations_subform[ReservationID].form
What I want it to do is when you double-click on the Reservation ID in the
subform datasheet, it opens the subform in form view to that specific record.
What the above macro does is open a parameter box. If I enter the
Reservation ID number into the parameter box, it opens the correct record.
However, I don't want that extra step in there (the parameter box). Is there
a way to avoid this?
double-clicked.
I've got a macro set on the OnDblClick property as follows:
Action: OpenForm
Form Name: Reservations_subform
Where condition:
[Reservations]![ReservationID]=[Forms]!Reservations_subform[ReservationID].form
What I want it to do is when you double-click on the Reservation ID in the
subform datasheet, it opens the subform in form view to that specific record.
What the above macro does is open a parameter box. If I enter the
Reservation ID number into the parameter box, it opens the correct record.
However, I don't want that extra step in there (the parameter box). Is there
a way to avoid this?