Hello

I wonder if someone would mind helping me with this. I need to create a search form that a person inputs criteria and then the results are displayed on the same form. If there are multiple results for the query I would like to be able to 'double-click' on the record that I want as displayed on the form and have it open up in form view for that record, for printing and ease of use. The table itself has many fields and this would save the user scrolling across the page and then posssibly losing their place.

Many thanks in anticipation; I have struggled with this one for a while!

Thanks.

in general, create the master search form and a subform that displays the basic info for the matching records of the search.

in the subform, place the code in the OnDoubleClick event of a field in the subform to open another form that displays all the data for the selected subform record.

i generally lock all the fields in the subform, except the one that i allow the doubleclick on.

i also set the properties for this field to a different foreground color and underline it (like an html anchor) so that the user knows it's 'clickable'.

hth,
al

How's your understanding of code. I can send an example which would probably suit your purposes, but don't want to explain all the code.
If you're familiar with VB is fairly easy to follow.