RE: IIf statement in criteria

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!

"Chip Coutts" wrote:

> 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?
.

Relevant Pages

  • IIf ststement in criteria
    ... I have a switchboard with an unbound combo box. ... I would like to be able to display all records in the table ... if nothing is selected in the pulldown. ... The True condition works, but I cannot get the False condition to return all ...
    (microsoft.public.access.queries)
  • Re: More Switchboard Buttons
    ... The problem is getting a list of all macro groups to display in a combo box. ... So my 97 Advanced SBM works just great ... Now go to the code behind the Switchboard form. ...
    (microsoft.public.access.formscoding)
  • Re: =SetTimer()
    ... This is code that I use to display a splash screen i.e. Logo etc for a ... Private Sub Form_Timer ... > ' Close the Startup form, and open the Main Switchboard form. ...
    (microsoft.public.access.formscoding)
  • Wait for a form to finish display before continuing
    ... a "switchboard". ... I would like to display another, ... as soon a the query ... the form no longer renders. ...
    (microsoft.public.exchange.misc)
  • Re: Q. Opening a form from switchboard . . ..
    ... www.pcdatasheet.com "Jim Jones" wrote in message ... > However, this form relies on other forms being opened at the time, to> display the related fields properly, because in some fields I have ... > How should I properly set up the given form, so I can open it directly> from my switchboard and display what I need the user to see? ...
    (microsoft.public.access.formscoding)