User Specified Filter
I have looked through the forum, but I have not found an answer to this issue yet, so maybe someone can help me.
I am using a form with 4 unbound fields to filter my main form. The problem I am having is if the user leaves the filters blank it won't show any records. Here is the criteria that I am trying to use in the query behind the main form, but please keep in mind there needs to be four filters possible.
IIf(IsNull([Forms]![TRADE ADD FILTER]![TRADEID])=False,([Forms]![TRADE ADD FILTER]![TRADEID]),"*")
Does anyone see any problems with this or how I could make this work?
I have looked through the forum, but I have not found an answer to this issue yet, so maybe someone can help me.
I am using a form with 4 unbound fields to filter my main form. The problem I am having is if the user leaves the filters blank it won't show any records. Here is the criteria that I am trying to use in the query behind the main form, but please keep in mind there needs to be four filters possible.
IIf(IsNull([Forms]![TRADE ADD FILTER]![TRADEID])=False,([Forms]![TRADE ADD FILTER]![TRADEID]),"*")
Does anyone see any problems with this or how I could make this work?
