Controlling the Row Source with Code (1 Viewer)

[girobert]

Does anyone know how to control the row source using VB? I have a problem that I think I can fix IF I can force the row source property to retrieve data when I want it to. I need to make it retrieve data more than just the first time the combo box is open. Any ideas? Thanks for any help

 

[charityg]

If your combo is based on a query which has a changing criteria, you can just requery the combobox with

cboName.requery

Or you can set the rowsource and then requery with

cboName.RowSource="Select this from Table where Blah Blah"
cboName.requery

Let me know if I can be of further assistance.

~Charity