report open by clicking on record in datasheet

[seeker]

I have a button on a form which opens a query in datasheet view. I would
like to click on a record and have a predesigned report open about that
record. How is this done. I have looked at the property sheet of query and
see nowhere I can put a module.

 

[Duane Hookom]

I think you need to create a form with the code and then view the form in
datasheet view.