By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,829 Members | 670 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,829 IT Pros & Developers. It's quick & easy.

combo box not updating

P: 9
I'm currently using Access 2003 to create a simple form. I am using two tables of information to go into this form.

One table I named "Categories" with fields of "CategoryID" and "CategoryName"
The other table is "Products" with fields of "ProductName", "ProductID", and "CategoryID". I have a relationship between the two so each product is in one of the selected categories.

I created a form with two combo boxes. The first combo box for the "Category" and the second for the "Product". When I select the a category, the product combo box will display the correct products, but if i switch categories the product combo box doesn't update, it just remains the same.

I have check my row source many times and everything appears to be correct.

What am I doing wrong??

THANK YOU
Feb 12 '09 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
Hi, and Welcome to Bytes!

If you want Access to change the contents of one combo in sympathy with the other you will need to change the rowsource property of the combo using VBA code from the After Update event of the first combo.

We have an Insight article on Cascading Combo/List Boxes which may help you with this.

-Stewart
Feb 12 '09 #2

P: 9
Thank you very much, works perfectly.
Feb 13 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.