Date Query for Combo Box & help w/ 2nd Combo Box

[ewassmer]

Thanks. I'll be trying out the autofill mentioned in your link.

Unfortunately, I have encountered another problem. The 2nd combo box does not refresh when I change the date in the 1st combo box. I have attached an updated sample db for you to view. Please let me know if you have any idea why the product combo box won't refresh.

[pbaldy]

If you look at my example, there's code in the after update event of the first combo to requery the second. You don't have that.

[ewassmer]

I added [Event Procedure] to the after update event. The second combo box still does not change when I change the first box. Any ideas?

[ewassmer]

Oops, I misunderstood. I didn't realize I had to click the ellipsis. I used the first coding and it seems to be working just fine. Thanks!!

[pbaldy]

Glad you got it working.