Filter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chey - 20 Jan 2006 23:50 GMT

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

Reply to this Message

Duane Hookom - 21 Jan 2006 13:52 GMT

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?

Signature

Duane Hookom
MS Access MVP
--

>I have two combo boxes
> vendor number and month1
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message