Filter by multiple values entering by end user

I have a continuous form and trying to insert a apply filter and a reset
filter buttons. So users can filter by any criteria they want to. I have the
following fields based on a query and table:

Field and description
Case: autonumber
InputDate: date
Input by: combobox
Trandate: date
Type: combobox
Branch: combobox
TranDay: text
TranMonth: text
TranYear: text
TranQT: text

Also I wish to have some kind of print feature that users are able to print
result.
please help, thank you in advance!

This article:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
includes a sample database you can download and use as a guide to build this
kind of form.

It includes one extra line of code to add to apply it to a report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"James" wrote in message
...
I have a continuous form and trying to insert a apply filter and a reset
filter buttons. So users can filter by any criteria they want to. I have
the
following fields based on a query and table:

Field and description
Case: autonumber
InputDate: date
Input by: combobox
Trandate: date
Type: combobox
Branch: combobox
TranDay: text
TranMonth: text
TranYear: text
TranQT: text

Also I wish to have some kind of print feature that users are able to
print
result.
please help, thank you in advance!