Hi,
I've got the follwing issue.
I have a command button on a form, which selects a query after beeing pressed. The data from the query is a combination of data from 3 tables.
Now I want to make a step in between. I want to give the users the possibility to restrict the output of the query.
E.g. The query previously showed all staff. Now the user selects only one department (maybe a combo box having an event procedure...) and when they press the button the query shows only the staff from that department.
I understand that that means I want to enter a criteria in the query with the help of the form.
The department actually is already part of the output from the query.
I really don't know if this is possible and how to do it?
Anybody out there with an idea? :)
Cheers