Web Development

Ask something
Discussion Locked

Access Datasheet Find Record

0 helpful
5 replies

by yatst

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Which event to I place the code in, for a form in datasheet view, so that when a user dbl-clicks the area it will open a new form to that item.

5 replies

by r. a. caluste

there's the dblclick event procedure and the click event procedure. to open a new form, you can use the docmd.openform method.

hope this helps.

by kees.valkenswaard

The DoCmd as described in answer #1 will work. It may be useful to add a button and add with the wizard the action open a form. This will generate the code as desired. You may need some filter. This can also be incorporated in the wizard, showing you the required code.
That code you add to the double click event.
Good luck

This discussion is closed to new replies.