Filter

G

Guest

I have two combo boxes
vendor number and month1
I did a find record with combo box for the vendor number-Works great.
Now I need it to work along with month1. This combo box list all 12 months
So if December is selected and then i choose a vendor number
That vendor number and that month show.
How can I mix this all into one?

Thanks
 
D

Duane Hookom

We don't know if the month number is returned or a text value. Also, are you
using the Where Clause in the OpenReport method or hard-coding control names
in your query?

Could you share your SQL view and tell us which date field you want to set
the criteria against?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Help 0
Access Access variable string for export 0
2nd Combo box gets only the first record 1
filtering a query for charts in a form 3
Creating An Access Report To Group Payments Of Equal Amounts 1
Find 1
Help with Query to find Month 19
Combo Box for a report 3

Top