Like "*" in a iif statement

[zkoneffko]

I have a drop down menu in a form and for the default value I have it set to "View all Districts" so the use can simply view all districts instead of choosing one from the dropdown. I am using an iif statement and trying to use the Like "*" function if the drop down is equal to "View all Districts" but the like function doesn't want to work in an iif statement. It seems like it's looking for the exact phrase " Like "*" ", and not using it as a function. Can anyone help me with this? Here is my iif statement:

IIf([forms]![Main]![DistrictList]="View all Districts",Like "*",[forms]![Main]![DistrictList]")

Thanks for your help.

 

[Simon_MT]

When you open the a form if the drop-down is null then:

(VB) "[District] like '" & [forms]![Main]![DistrictList] & "*" & "'"

This will produce all Districts whilst if the District is populated then that District.

Simon