ComboBox not being updated with latest RS changes

[BlackBearDude]

I have a category table which gets maintained by the user. This works fine. Another form uses a ComboBox containing those categories. Problem is that after changes are made to categories, they are not being reflected in the ComboBox.

I have checked the underlying table and the additions/changes are present. The recordsource for the combo is a SQL that simply pulls the category descriptions and displays them in control.

I perform a requery on the RS based on the SQL, this should reload the RS with the latest, right?

Then a refill of the combo should cause it to show the latest, right?

Obviously I'm missing something here...

Any clues?

 

[BlackBearDude]

FYI - Problem Solved

I've corrected the problem. Don't know why the RowSource needed to be reset, but it works.


de.rsSqlCatCombo.Requery
Set cboCat.RowSource = de