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.
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.