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?
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?
Last edited: