"EVENT Procedure" on a Query

[nyrob609]

Hi,

I need some assistance, I created a searched form that opens a query with the records that I want. What I would like to do is to be able to double click on a field an open a form with the full details of that record.

Is this possible on a query I don't see an Event option on the fields properties like in a form or subform datasheet view.

Any assistance will be greatly appreciated.

Thank you

 

[SOS]

Queries do not have events. Create a form that has the query as the recordsource (you can make it datasheet view to look just like a query) and then you can use the control's double-click event to open another form for the details.