Filter Question

[Golfinray]

I am trying to figure out how to filter a report with a cbo on a form. First,
I tried putting Forms!"06-07 plans"!me!combo87 in the criteria of the query
driving the report. I never got that to work right because it always asked
for parameters. Now I have set the click event of my combo (the combo can be
set to A, B, C, or D plans) and I used docmd.openreport "06-07
plans",acviewpreview,,combo87. I then turned the filter in the report to on.
All is does now is open the report, not filter the report. What am I missing?
Thanks a bunch!!!!

 

[Jeff Boyce]

If it is "always asking for parameters", you have either spelled the
selection criterion differently than the actual name of the form and
control, or the form isn't open when you try to run the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Ron2006]

This would NOT be the format

Forms!"06-07 plans"!me!combo87

More probably it should be:

Forms![06-07 plans]!combo87

If you use the query wizard in creating the query, it will format it
correctly.

Also you will probably need to requery the subform in the afterupdate
event of the combo.