One combo box linked to another

[ghard123]

I cannot get this to work. I have a categories combo box and a products combo box. I want the products box to show only those products that are relevant to the particular category selected in the category box.

I can get each to show their particular entries but when I try to link them the products field populates with the same items even though I change the category box. It looks like I need the product box to refresh???

this is the line in the products box;

SELECT Books.BookID, Books.BookName, Books.CategoryID FROM Books WHERE (((Books.CategoryID)=Forms!Combo1!CategoryID));

Any help appreciated thanks.

 

[MStef]

Send a short example of your MDB, (Access 2000 or 2002-2003).

 

[ghard123]

Thanks. Here it is...(I think)

View attachment combo box test.mdb

 

[John Big Booty]

OK; first up the criteria for your Combo3, should be;

[Forms]![frmbooks]![Combo1]

Secondly you need the following code in the On Change event of Combo1;

Me.Combo3.Requery

Make those changes and your Cascading combo will work.

 

[ghard123]

Thanks heaps. I have been trying to work this out for over a week.