ListBox RowSource Update Not working in 2003

[Access0307]

I'm not sure if this is the correct place to post this, but I have a database that I created in Access 2003, that was working fine until a few of the users got Access 2007. I did not convert the database since the majority of users are still using 2003.

Anyway there is one form where users select multiple combo boxes (each populated based on the previous combobox selection). Additionally, a list box populates based on the first combo box selection.

For some reason the list box stopped populating for Access 2003 users. I'm using pretty generic code to update the listbox:



strSQL = "queryinfohere"
listbox.RowSource = strSQL

I haven't changed anything in the code.

Any ideas why this would suddenly stop working only for Access 2003 users?

Thanks!

[ajetrumpet]

well, the only thing I notice that's missing here is the "listbox.requery" method. Are you aware, that without that, your listbox cannot get the secondary or third list that you're looking for? You have to requery it, sir.

other than that, there is nothing wrong with the code that you're using. from what I see anyway...

also...in terms of 03 and 07 versions, listbox code was not changed, at least not to the effect that that it would affect you in this scenario...