Select record in datasheet and open another form

[dbar10]

This probably is fairly simple but I have never done it before. I have an open datasheet from a ClientLoglistqry and I want to select a single record in this datasheet and have it open to another form with the full detail of that record from the Client Log query using logID as the criteria. Somebody, please, tell me how to do this.

 

[dhookom]

If you really want to use a datasheet, create a form and view it in datasheet. Use the command button wizard to create a command button to open the single record form and then cut and paste the code into the double-click event code of any appropriate text box.

Duane
Hook'D on Access
MS Access MVP

 

[dbar10]

Thank you very much. Of course that worked great.