Adding Records with double click

[honor401]

I have a query fields that pulls from a table
discription
upc
product id
vendor
price
in the description field under criteria I have
Like "*" & [Search by word:] & "*"
I have a form but when I open it I am asked for search criteria
I would perfer, instead of the standard access question box, a blank form with the four fields and you can search by any of those fields (except price) and have it apper in datasheet view.

Once I have that data I would like to be able to double click on one of the products that the query pulls up and have it add a record into a temp table. Kind of like building an order for shipment.
so I would
search
double click selection
search
double click another selection
and so on and so on.

Any ideas would be greatly appreicated...
thanks in advance.
Honor401

 

[honor401]

Thank you

No actually that isn't what I was going for but I have decided to get the raw program working before I start messing with the foo foo stuff....
thanks for looking though and I appreciate your help
Honor401