I have a problem. I have a list box based on the Annuity carrier field from a table called "ALL RECORDS". When the user chooses which Annuity carrier they would like, I need another combo box to populate from a products table that will only show the products with that annuity carrier.

The fields in the Products table are: Annuity carrier, Product, Product Age, Max Age.


Thanks for the help, guys!!!!

This is a super source. The TechnoWeenie web site: http://www3.sympatico.ca/qaissuper/Index.html

Check out the zip file for "ComboBoxes" and there's a sample for limiting a combo box based on another.

Matt