Filtering a query...

[simonI]

i have about 14 fields that relate to subjects, basically i want to be able to run a query that searches for all the people who have choosen the module and report bak who they are..

now i know i can do this 14 times over but is there a way that the user can choose the subject first and the query will then run hence meaning only one query/report.. i thought of using a list/combo box but have absolutely no idea...

im very much a novice but any help would be most apreciated!

cheers

si

 

[Matt Greatorex]

Would it be possible to use a listbox to display the names of all modules?

Limit it to only allow the user to select one item at a time (set the Multi Select property to None) and add an event under the After Update property to run your report, based on whichever value was selected.

 

[pbaldy]

14 fields for subjects hints at a normalization problem. That said, if your question is how to search all 14 fields for the same subject:

SELECT Whatever
FROM Whatever
WHERE Subject1 = "Math" OR Subject2 = "Math" OR ... Subject14 = "Math"