Selecting all thru an IIF statement

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

I have a form called MailOut that has a check box called cbxTitleAll. And a
combo box called cboTitle1 (this could be Mr, Mrs etc)


What I want to happen is that if cboTitleAll is true then all records
(including Mr, Mrs, Ms,Dr nulls, and anything else in there) are selected
otherwise it selects whatever is in cboTitle1

This is what I have put in the query

IIf([Forms]![frmMailOut]![cbxTitleAll]=True,"*",[Forms]![frmMailOut]![cboTit
le1])

But I think it is looking for "*" rather than *

How can I do this?

Thanks
 
Dave,

[Forms]![frmMailOut]![cboTitle1] Or [Forms]![frmMailOut]![cbxTitleAll]

- Steve Schapel, Microsoft Access MVP
 
Back
Top