Is it possible to return a query that includes a Command Button alongside each record

[daveatthewell]

Data is entered into my database via a form whose data source is a query which queries two or more tables. If I'm looking for a person in the database, I can either filter the form or run a query. The former returns a form whose source is effectively the filtered list, but then you have to step through each filtered record until you find the one you're looking for and if you're looking for Smith, there can be a lot of them. If I search by running a query, I can opt to display the results in datasheet view and then quickly find the correct record. I COULD update data here but with something like 20 fields, there'd be much scrolling across the record to find the field I'm looking for. I COULD return the results in a subform and thus allowing click events on individual fields, but it would be so nice if it was possible for the search query to return the results in datasheet view but with an additional field at the end (or beginning) which contained a command button that I could click to jump to the record and view it in the data input form. Wishful thinking or possible?!!!
Any thoughts from the experts?

 

[Norie]

Couldn't you use a continuous form set up to appear like a data sheet?

 

[ranman256]

A continuous form can.

 

[daveatthewell]

Thanks Nori (and ranman256) - didn't even think of continuous forms as a possible solution. Doh!
Thanks again