Selecting all thru an IIF statement

[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

 

[Steve Schapel]

Dave,

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

- Steve Schapel, Microsoft Access MVP