Refreshing combo box after other contingent combo selection changes

[Newby]

I have a form which has two combo boxes. The first combo box is say actice/inactive. The second combobox limits customers based on their status. When I open the form and select a status option, my customer combo box is filter correctly, but if I change the status, my customer combo box doesn't not refresh. How can I make the customer combo box clear and reload every time the status code change?

[June7]

Try Requery code in the status combo AfterUpdate event and/or customer combobox GotFocus event. http://www.datapigtechnologies.com/f...combobox2.html