Double click event in subform (Datasheet view) in access 2007

1
votes

I have a sub form. I want to create a double click event on its record to show its detailed view.

I am not able to see 'Double click' event for the subform. Someone pls help.

1
ms-accessvbams-access-2007
msdn.microsoft.com/en-us/library/office/… – Roland
the sub form control has only two events 'On Enter' and 'On Exit'. Also, the sub form - form properties has double click. But that event is working on entire form. In that case, if I double click inside cell, its not accepting the double click. It allows me to double click outside the cells. – sabari
Inside the cells you have to use the events of these. Choose a cell (e.g. the ID) and put the action in there or, if you must, in all of them – Roland

1 Answers

2
votes

Open the subform in design mode. Select the form properties. Add a double click event to the form with your procedure in it. Close and save the form. Re-open the sub form in the main form. To the left of the data double click the grey box and your event will run.