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

Filtering Combo Boxes/ No Duplicates

P: 27
I have a form (frmOrder) which uses a subform, tblOrderLine, the field 'Product Type' is stored in tblProducts, I have a combo box (cboPType) which is linked to the product type field in tblProducts, however it contains repeated types (i.e. 30 books, 5 DVD's); I would like to filter the next combo box (combo68) which contains a list of products (linked to tblProducts) and, i would like to filter the combo box, so that if, say books are selected in the product type, the actual products list will change...how can i do this?
I'm new to Access so any help will be hugely appreciated THANKS IN ADVANCED!!!!
Feb 10 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
Check out this tutorial (Example Filtering on a Form.) and let me know if that helps you to do what you need.
Remember, we can be more precise if required so don't be put off if it's beyond you at the moment.
Feb 11 '07 #2

Post your reply

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