Can you post the VBA code that's not working?
It sounds like the rowsource property is being set before the variable is initialized...