query to open record in form

[john]

in my system i need to cancel orders. to do so i have to go through each
customer in the order form to find the correct order. is there a way of
searching through the orders to match the customers name and open the order
detail in a FORM and NOT TABLE

thnx in adv

 

[Larry Daugherty]

the first thing that comes to mind is a combobox based on a query
based on your orders table.

There are other ways.

HTH