Making search results clickable? (1 Viewer)

I have 3 text fields on a form that I search by. I have the search query action set on a button, which produces the results in a datasheet view. Is there any way that I can make the records in the datasheet view clickable so I can select the record and go to the form to update the data?

Any help is greatly appreciated! Thanks so much!

Shellsbells

the button will open frmResults. This uses your search query as multi record view.

on frmResults , at the header, put a button to open in detail 1 record.
docmd.openform "frm1Rec",,"[id]=" & txtID

this will open the form on the 1 record the cursor is on.

In case the field is text (and I think you've got a missing comma):

http://www.baldyweb.com/wherecondition.htm