How do you add a query to a cbo box were the results appear in a separate cbo box?

[wedd]

Hi everyone, how do you add a query to a combo box so when a user selects from the combo box 1 on a form in access 2007, that only the list that matches a specific criteria will appear in a separate combo box 2, and the selected list will be restricted will only appear based on the list selected on combo box 1? If you have any examples of how you achieved this, or any examples would be very helpful.



Thanks for your contributions:friends: