Dbl Click datasheet record to open another form

[jbphoenix]

My form requires a user to enter in an RMA number then press a btn which displays the results in a subform with a datasheet view. The RMA may have multiple lines. The user needs to find the correct line based on part number. Once the correct line is chosen the user fills out another form about the actual RMA test results for that particular part.

So is it possible for the user to double click on a line in the subform and then have another form open?

 

[kidrobot]

Not sure about this but I know you can do this if you use a listbox instead of a subform. Maybe someone else will know.

 

[boblarson]

You are able to go into design mode and in the double click event for the text box that is the one you want to double-click in, put the code you want.

 

[jbphoenix]

Ok - i have it set up as a listbox instead of a subform. but I can't figure out how to double click on a line item and then have another form open.

 

[kidrobot]

On double click event

Docmd.Openform "Form Name"