Query help - Enter Parameter Value

[piet123]

i'm new to access, please help. In the query's underlying table is a field for "Customer Name". The query generates a Report which calculates the "Total Cost" for a specified customer. In the query I have set the criteria for the 'customer name' field to [Type the Customer's Name]. When the query runs, the Enter Parameter Value box prompts for "Type the Customer's Name". My question: Instead of having to type the customer's name, I want to display a combo box (or drop list) from where I can select a customer's name. The report will then display the totals for that selected customer. How do I do this ? I will appreciate any suggestions. Thank you.

 

[PremierComputer]

Create your form with combo box on and a command button to launch your report. Then in the input parameters field type :-

Forms![frmMyform]![cboMycombo]

This should do the trick
Steve.

 

[piet123]

Thank you

Create your form with combo box on and a command button to launch your report. Then in the input parameters field type :-

Forms![frmMyform]![cboMycombo]

This should do the trick
Steve.

You make it sound so easy - will try that, thank you.

I have more questions but will post them later.
Piet.