Using a combo-box entry as criteria for a query

[matpj]

Hi, it seems the more I do to this database the further over my head I am going!

I have a 'customer' combo-box that is filled out by looking up from a query.

I have created a second query from several Oracle tables, that will list all of the services that the specific customer has ordered.

On the form with the customer combo-box, I want to have some way of going to another form showing the results of the second query.

In basic terms, the user selects the customer on the first page, and then clicks a button which opens up a form with all of the services that the relevant customer has ordered.

Can anyone give me simple instructions as to how I might achieve this.

the way I see it, is the 'services oredred' query needs to have a criteria in it for the customer - which 'looks' at the customer combo-box in the form (this combo-box stores its data to an Access 2000 table).

 

[ShortTexan]

This is a little dirty but it works quite well.
Create a hidden (not visible) text box on Form1. On Form1 combobox create an after update event that writes the results into Hidden Textbox1. also in this same after update event (if you want this much automation) place a DoCmd that opens Form2. Have Form2 created from a query that has Criteria that looks at Form1 Hidden Textbox1.
I use this method often. Dirty but works.