Solved: Combo Box question - easy one I think

[Mavver]

I have a combo box which is linking into a query.

To do this I just place the name of the combo box in the critriea section of the query

[Forms]![frmLADetails]![Combo43]

However, inside the combo box there is a null record, so that the user can choose not to select any.

For instance, the user can select Apples, Oranges or leave it blank.

I am trying to get the criteria in the query to work, but struggling a little to finish it off.

I have got as far as the following but it keeps on bringing back no records instead of all the records

IIf(IsNull([Forms]![frmLADetails]![Combo43])=0,[Forms]![frmLADetails]![Combo43],Like "*")

Can anyone see what I am doing wrong

Thanks in advance

Mav

[mattj]

Use
[Forms]![frmLADetails]![Combo43] Or [Forms]![frmLADetails]![Combo43] Is Null

I also recommend that you give your controls a meaningful name (makes things much easier)

HTH
Matt

[Mavver]

ta for the help

Mav