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