want to double click on a query row to open that data in a form

[pduncan]

I want to have a user be able to run a query and get the results in a data-sheet. When they find a particular row that has data elements that need editing, they double click that row which would open that row in a form that the user could edit and then save.

Can someone please give me some pointers?

Thanks, PDUNCAN
Memphis, TN - USA
When I die, I want to die like my grandfather-- who died peacefully in
his sleep. Not screaming like all the passengers in his car.

 

[PHV]

Follow the form wizard to create a DataSheet form based on your query.
Then you'll open the detail form in some event procedure of this datasheet.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pduncan]

thanks - how do I have the form open on the on-click event procedure of the (subform) data-sheet?

Thanks, PDUNCAN
Memphis, TN - USA
When I die, I want to die like my grandfather-- who died peacefully in
his sleep. Not screaming like all the passengers in his car.

 

[PHV]

In the VBA help file take a look at the DoCmd.OpenForm method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244