Combo Box Not Workin

[main-man]

Hi can some one please help me?

i have a query that uses parameters...e.g dates and also a combo box where a person on a form can choose the relevant sector.

I have made a button on a form which when depressed should run the query, but its not working?

im not sure how 2 link it to the query?

When i run the query on the query screen through design view it works fine when i enter the query data.

Im not however sure how to run it or use it or make it work with the button linked to it on the form? (when pressed it shud run a report based on what is selected in the combo box) can sumone provide em with sum info plz?

 

[ColinEssex]

you could assign the query to a macro and use that (macro) in the on-click event of the button.

Col

 

[MStef]

In query criteria put:
Forms!FormName!FieldName

 

[MStef]

Do you want to run a query or a report ????