Changing the ListRowSource of a ComboBox at runtime in a DAP

  • Thread starter Thread starter Sebas
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADP or DAP 4
Another Data Access Page Question 2
fill a field from a combobox 7
DAP questions (Data Access Pages) 3
Problem printing a DAP 3
Passing info from a DAP 1
IIS + DAP 1
2007 Runtime licensing 1

Back
Top