Query criteria from Combo box selection

[caniread]

I want to filter by a combo box selection on a form that then generates the report from that query. I got almost everything to work except it asks for the parameter when I generate the report. If I type in the parameter it does generate the report. I am not sure what I am missing?

[NoellaG]

Hi,
this happens when the name of the form or form control is misspelled. Check the name of the combo box on the form and see if it matches with the expression.
By the way, it is good practice to give all your objects on the form a correct name . Combo11 doesn't mean much. Better to name it cboArea or something like that. And it's easier to work with object names that don't contain spaces.

Kind regards
NG

[caniread]

Not the spelling. I think it for some reason isn't getting the combo box selection that I have selected from the drop down list.

Hi,
this happens when the name of the form or form control is misspelled. Check the name of the combo box on the form and see if it matches with the expression.
By the way, it is good practice to give all your objects on the form a correct name . Combo11 doesn't mean much. Better to name it cboArea or something like that. And it's easier to work with object names that don't contain spaces.

Kind regards
NG

[caniread]

Made the row source a query instead of a table and that fixed it.