If I trace through, MyVariable changes value, but not the SQL. It still using the old value of MyVariable.

One alternative to Naomi's suggestion is to create a parameterized view to use as the RowSource, Requery the view and then Requery the combo.