IIf ststement in criteria

C

Chip Coutts

I have a switchboard with an unbound combo box. If I want to display only
the records for CampusCode=1, I pulldown that CampusCode on the switchboard,
and the query has criteria [Forms]![Switchboard]![CampusCode], and it works
fine. However, I would like to be able to display all records in the table
if nothing is selected in the pulldown. I have tried
IIf([Forms]![Switchboard]![CampusCode] Is Not
Null,[Forms]![Switchboard]![CampusCode],????)
The True condition works, but I cannot get the False condition to return all
records.
Any thoughts?
 
C

Chip Coutts

I am embarrassed to reply to my own post, but I did find a solution...
IIf([Forms]![Switchboard]![CampusCode] Is Not
Null,([Forms]![Switchboard]![CampusCode]),([Assessments].[CampusCode]))

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Switchboard won't cooperate 3
Help with form 0
Me![Option1].SetFocus error 1
Open a form from a combobox on the switchboard based on a field inthe subform 1
Access, how to base a query field criteria in a macro 0
More than one criteria value in a query 2
How To Display Message "No Records Found" In Forms 1
Criteria to return all records if selection from form is null 4

Top