DB No value given for one or more required parameters.

[Desert Bear]

I'm using the Combo box wizard in a form based on a query.
I get "No value given for one or more required parameters", but the wizard hasn't requested whatever parameters are missing. How do I solve this?

 

[Dirk Goldgar]

I'm using the Combo box wizard in a form based on a query.
I get "No value given for one or more required parameters", but the
wizard hasn't requested whatever parameters are missing. How do I
solve this?

At a guess, you've chosen a query as the rowsource of your combo box,
and that query has a reference to controls on a form that is not open
(except maybe in design view). If this is the problem, temporarily
create a similar query that doesn't have any such references, tell the
wizard to base the combo box on that query, and then change the combo
box's RowSource property back to the original query after the combo box
has been created.

 

[Desert Bear]

Thanks, I think that is the problem.