Using a record from a search

[Les Blair]

I have a routine that does a search and return all the records from a table that meet the request. This could be 0 to any number. It brings it back in a continious display on a form. Is it possible to be able to place my mouse next to the line I want and click it and then be able to read the info from that line to use in a docmd to go to the record and display all the information in another form. I hope that this is not as confusing and it sounds to me. I really just want to be able to position my cursor and use the field in that row.

 

[KeithG]

Sure, you can use the on click event of the form. Once you click on a particular row it will become the current row with focus and you can reference the forms controls for the values from the record.