View Full Version : Controlling the Row Source with Code


girobert
06-25-2001, 12:44 PM
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
06-25-2001, 12:57 PM
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