Hi, I'm very new to Access and have question.
I would like users to get filtered report data based on a combo-box or similar.
How do I do this?
I tried this:
1) I created a form "frm1" with a combo-box "combo1" choosing from values in a column in query "qry1".
2) I then made a query "qry2" like this:
SELECT *
FROM qry1
WHERE column1=!Form!frm1!Combo1;
But when I go to qry2's datasheet view expecting a filtered result based on the chosen value in the combo box I get a message box requiring me to "Enter parameter value" of "!Form!frm1!Combo1". If I enter a value the query successfully filters. But that's not how I want it to work as you can imagine
What am I doing wrong?
Suggestions on alternative ways?
Thank you!
I would like users to get filtered report data based on a combo-box or similar.
How do I do this?
I tried this:
1) I created a form "frm1" with a combo-box "combo1" choosing from values in a column in query "qry1".
2) I then made a query "qry2" like this:
SELECT *
FROM qry1
WHERE column1=!Form!frm1!Combo1;
But when I go to qry2's datasheet view expecting a filtered result based on the chosen value in the combo box I get a message box requiring me to "Enter parameter value" of "!Form!frm1!Combo1". If I enter a value the query successfully filters. But that's not how I want it to work as you can imagine
What am I doing wrong?
Suggestions on alternative ways?
Thank you!
