Filter Form

[Wesley Appeldorn]

I am trying to create a form that will filter records on another form.
Using multiply fields. Some fields will not be used all the time. Also need
to be able to use wildcards.

I have tried using a command button that use's the link criteria.When i use
it that way it has to be case sensitive. No wild cards can be used.

I have also tried going into the query of the form i am trying to filter and
had added links to the fields of the filter form. It allows wildcards but if
one field is blank it does not show a record.

Say i got two fields
1. Name
2. ZipCode

If i wanted to filter by zipcode.
I simple type in the zipcode and the name is not used. I would have to put
a * in the name to find the records. If i did not no records would show up.

If I wanted to filter by name but only new part of the name.
Then I would need to *partName* in the name and * in the zipcode.
Only problem is that if the zipcode is null it does not show that record.
For instance Foreign Countries.
So in my query i have for a criteria is (Like [Form]![filter]![Zipcode] or
is null) by doing this it shoes me the record i want but all records with no
zipcode.

Any help will be appricated.

 

[Penguin]

Try this link:
http://www.mvps.org/access/resources/downloads.htm

Scroll down to QBF

This should help.