 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / May 20083 combox box on the form with rowsource
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, >I have 3 comboboxes on the form and all of them have a query for their > row source. [quoted text clipped - 7 lines] > > Your information is great appreciated, 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 >>I have 3 comboboxes on the form and all of them have a query for their >> row source. [quoted text clipped - 16 lines] > > Carl Rapson 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.