3 combox box on the form with rowsource

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I have 3 comboboxes on the form and all of them have a query for their
row source.

It seems MS Access running teh query in the background to get the list
which is very slow to load the form.


Is it possibe to link row sourrce at run time after form load that
makes it easier for the user?
If yes, can you please give me a link or a sample?

Your information is great appreciated,
 
iccsi said:
I have 3 comboboxes on the form and all of them have a query for their
row source.

It seems MS Access running teh query in the background to get the list
which is very slow to load the form.


Is it possibe to link row sourrce at run time after form load that
makes it easier for the user?
If yes, can you please give me a link or a sample?

Your information is great appreciated,
Click to expand...

In the Form_Load event, set the RowSource property of each combo box to the
appropriate string. Example:

Me.cboBox1.RowSource = "<your query here>"

Then be sure to clear the RowSource property of the combo box.

Carl Rapson
 
Carl Rapson said:
In the Form_Load event, set the RowSource property of each combo box to
the appropriate string. Example:

Me.cboBox1.RowSource = "<your query here>"

Then be sure to clear the RowSource property of the combo box.

Carl Rapson
Click to expand...

Correction to last statement: Then be sure to clear the RowSource property
of the combo box in its Properties window.

Carl Rapson
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Back
Top