Thanks, Bill, for this good advice.
Can you, or anyone else tell me how to get more information on the method described below? (Maybe using less code if possible) Seems to make perfect sense but I can't seem to find any elaboration in the threads. Thanks much - Trent
An additional way to speed up Form and Report loading is to specify the Form/Report Recordsource when the Form/Report loads, in the On Load event of the Form/Report:
Me.RecordSource = "MyQueryName"
Me!SubformName.Form.RecordSource = "MySubFormQueryName"
Then specify the ControlSources of your TextBoxes etc.
Me!TextBox1.ControlSource = "Field1"
Me!TextBox2.ControlSource = "Field2"
Me!SubformName.Form!TextBox1.ControlSource = "Field1"
Then specify the RowSources of your Combos/Lists.
Me!Combo1.RowSource = "ComboQuery1"
Me!SubformName.Form!Combo1.RowSource = "ComboQuery1"
Basically, all Forms/Reports and Controls at Design Time should be UnBound.
On a stand alone app the performance increase is negligible, but Front End to Access on a Network, MSDE, SQL Server or Oracle should be very, very noticable.
Please let me know if this one helps!
Bill
Can you, or anyone else tell me how to get more information on the method described below? (Maybe using less code if possible) Seems to make perfect sense but I can't seem to find any elaboration in the threads. Thanks much - Trent
An additional way to speed up Form and Report loading is to specify the Form/Report Recordsource when the Form/Report loads, in the On Load event of the Form/Report:
Me.RecordSource = "MyQueryName"
Me!SubformName.Form.RecordSource = "MySubFormQueryName"
Then specify the ControlSources of your TextBoxes etc.
Me!TextBox1.ControlSource = "Field1"
Me!TextBox2.ControlSource = "Field2"
Me!SubformName.Form!TextBox1.ControlSource = "Field1"
Then specify the RowSources of your Combos/Lists.
Me!Combo1.RowSource = "ComboQuery1"
Me!SubformName.Form!Combo1.RowSource = "ComboQuery1"
Basically, all Forms/Reports and Controls at Design Time should be UnBound.
On a stand alone app the performance increase is negligible, but Front End to Access on a Network, MSDE, SQL Server or Oracle should be very, very noticable.
Please let me know if this one helps!
Bill