IIf statement to select ALL records

[lynxbci]

Hi

Have a simple query with input from a combo box. If the user selects 'All' i want to show all records.

=IIf([Forms]![frm_Dry_tow_Chart]![combo_customer]="All","*",[Forms]![frm_Dry_tow_Chart]![combo_customer])

I have tried "*" (As in above example) and tried 'Like"*"', Is Not NUll, none of which work.......

How is this done?

Thanks in advance

 

[John Big Booty]

Try;

= Like IIf([Forms]![frm_Dry_tow_Chart]![combo_customer]="All","*",[Forms]![frm_Dry_tow_Chart]![combo_customer])

 

[Kiwiman]

Howzit

Try...

Like "*" & [Forms]![frm_Dry_tow_Chart]![combo_customer] & "*"

 

[lynxbci]

Thanks working perfectly

 

[PhenomHTPC]

Try;

= Like IIf([Forms]![frm_Dry_tow_Chart]![combo_customer]="All","*",[Forms]![frm_Dry_tow_Chart]![combo_customer])

This prevented a ton of headaches! Thanks!