>If the RowSourceType is Alias, does the Requery have any affect on the ComboBox? If not, what do you do if it's an alias that was created with SQL elsewhere in the form? Do I have to rerun that SQL? Should I just put the SQL into a new method of the form and call that as needed?
Here is what I do. If I need to re-run the combo's SQL, I first assign combo to the empty string, e.g. RowSource = "", then run my SQL, then RowSource = 'myCursor'
You can put this code in the separate form's method and call when needed.
If it's not broken, fix it until it is.
My Blog