using multiple search options

[JamieC]

Hi guys,

I made a form to search some values in a table and print them in a report.
The form looks like this:

When clicking the "show report" button a macro is executed. In this macro I have the following code:

OpenReport -->
Report name: main
View: print preview
Where condition: [name]=[Forms]![searchfeedback]![namebox] And [week]=[Forms]![searchfeedback]![week]

Now what I want is a bit difficult.
I want to give users the ability to search by each option and by using multiple options.
i.e.
- When filling in the name and click the show button it gives all reports for that person.
- When filling in the name and selecting the weeknumber it gives all reports for that person in a particular week.

and so on with the id field, the date field and the supervisor field.

How do I create something like that?

 

[ansentry]

Post a copy of your db, and I will have a look for you.

 

[JamieC]

It took me a while to create a similar database.
For company reasons I cannot post the real database I use..

Here it is:

 

[ansentry]

Have a look at the attached sample, the work is NOT mine.

You should be able to use it for your database.