Unbound combobox sending Null to query

[Dartagnan]

My unbound combobox is based on query and shows cities. I am trying to send this value to a query used by a report. I keep getting no records. Finally I tried the following iif statement and determined the value being passed is null because I do get records when I use this as the criteria.

IIf(IsNull([forms]![frmReports]![cboCity]),"Anza","No")

Any thoughts?

 

[xenou]

Are you saying the combobox is empty when this happens? Why not choose a city, in that case so it won't be empty?

 

[Dartagnan]

No there are values in the combobox and I am selecting a value. Ultimately I want to be able to select more than one.

 

[xenou]

I guess you should explain how the query works. If the combobox is not empty, the problem is somewhere in how you are sending the value to the report.

Edit:
Or maybe you are incorrectly reading/referencing the combobox.

 

[Dartagnan]

Funny I have not had this problem until 2010. Form name is frmReports. Combobox = cbocity. Once a city is selected the user clicks View to open the "rptCityToWorkIn" report. The reports query has several columns but only one criteria which is [forms]![frmReports]![cboCity].

 

[xenou]

I see. Well that is the way I would have recommended you to set this up.

I take it you changed the criteria in the report query source to something like this (and then it works):
Nz([forms]![frmReports]![cboCity],'Anza')

You said you wanted to change the combobox to be able to pick more than one city. Is it possible the combobox is now in some kind of multi-select mode. What you have here, with the use of the combobox in a query criteria, would require the combobox to be single select (I'm ignoring the possibility of multi-valued fields which I know nothing about anyway).