Changing the ListRowSource of a ComboBox at runtime in a DAP

S

Sebas

Hi to all,

I'm developing an Access Data Page in Access 2002. I have a combobox
that is filled from a table. I would like to set the sql query that
fills the combo box at runtime.

Does anyone know how this can be done?

Thanks in advance

Sebastià Herreros
 
L

Larry Linson

Assuming you want to do this in the Form's module for a Combo Box named
"cboWhatever" from an SQL string stored in a variable named "txtYourSQL":

Me!cboWhatever.RowSource = txtYourSQL
 
Top