I have a problem list form that has a StatusCombo and a ProblemListBox.  Listbox is based on ProblemListQ. So when I choose a status, it only shows the appropriate records. (Works awesome)

Then I created a command button to show ALL PROBLEMS based on AllProblemsQ. (Works great) Here is the code for the button.

ProblemListBox.RowSource = "SELECT [ProblemID], [LegalName], [DateITNotified], [Problem], [DateDone] FROM AllProblemsQ ORDER BY [LegalName];"

After clicking on the ALL PROBLEMS BUTTON, it DOES show all of the problems (which is awesome), but if I go back and change the statuscombo to something else, it doesn't work anymore.

I assume I am missing a requery somewhere, but I don't know what kind of event to use and where or on what field the event needs to go.

Any help is appreciated!

---

Reply from Alex Hedley:

I presume ProblemListBox has a RowSource of AllProblemsQ with that having a Query Criteria based on the StatusCombo?

Since you have changed the RowSource to your Query, you will need to change it back to your original source.

You could use an AfterUpdate Event on the StatusCombo to reset the RowSource.