Simple answer any time you change the datasource of an object you have to use the Set yada yada in front
Just change the last line to

Code:
  Set DBCombo1.RowSource = myRst
You can leave the Me in there if you want but its not needed