I would like to limit the output of a query based on the value of a variable on an acces form.
I am sure the answer is simple but the syntax i don't know.
The original query is named qry_PDM_Measures and includes...
- Project Category
The combo boxes i want to control are on a form named frm_PDM_Results.....
When a value is selected from cboProjectCategory i want to limit the list in cboMeasure to those measures where Me.ProjectCategory on the form is equal to Project Category in the query.
Any help most welcome.