Using Query Output in VBA

[BlindEagle4283]

I have a form that will run a query based on order number and it will find the order info, now i want to augment it so that it will take the customer from that query and run another query for all orders made to that customer.

The problem i am having is with retrieving the data i want from the query automatically, how can i do this?

 

[BlindEagle4283]

Thanks for the advice, but I would still like to know how i can get the values from a query within a form in order use them in other places.

 

[KeithG]

To get the values from your query into your form use a sub-form and link the forms together by the Order Number field. You can also use the Dlookup function to retrieve values from a query.