Get criteria from the Form

[mauricionava]

Hello, I created a table with all the dealers I need to run the report with. Then created a form and inserted a combo box with the dealers table and a button to run the report. How can I set my query to pull whatever dealer is selected in the combo box in the form?

I have done this before with dates and it works like this

[Forms]![MyForm].[MyField]

How would it be if I want whatever is selected in the combo box to use it as the criteria?

Thanks

 

[lars7]

In the on click of a button or the after update of the combo box you could try this:

DoCmd.OpenReport "YourReport", acViewPreview, "", "CriteriaField='" & YourComboBox & "'"

 

[mauricionava]

I get all reports with no data.

Is there anything to put in the query criteria?

Thanks

 

[lars7]

Yes whatever the field name is for the dealers.