Query based on ComboBox (1 Viewer)

[RevJeff]

Hello everyone,

So I have a query that is based off of a ComboBox, which has 6 choices. It has the name of 5 different Shuttle Yards and the last choice is "All Yards". Below is the code in my query, but when I run it I get the following error. "The expression is typed incorrectly, or it is too complex to be evaluated...."

=IIf([Forms]![frmDashboard]![Yard]="All Yards","Mebane" Or "Hope Mills" Or "Wilmington" Or "New Bern" Or "Selma",[Forms]![frmDashboard]![Yard])

Thanks for any help you can offer.

 

[mike60smart]

Hi

Can you show a screenshot of your query?

 

[arnelgp]

actually the construct is wrong.
maybe this:

=IIf([Forms]![frmDashboard]![Yard]="All Yards", tableName.[fieldToDisplay] ,[Forms]![frmDashboard]![Yard])

 

[RevJeff]

I have attached a screenshot of my query and the ComboBox. Oh, and [Yard] is the name of the ComboBox.

 

[RevJeff]

Thank you arnelgp! That worked!

 

[arnelgp]

You're welcome Rev.