Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Saving Form is very very slow
- Thread starter Dbless
- Start date
I've had a similar experience myself. The way around it was to specify the form's Recordsource and listbox's/combo's Rowsource at run time. Create a backup of your DB and try this out on that.
Remove references from the property window to recordsources in you form and rowsources in listbox's/combo's .
In the form's on load event your code should look something like this.
Me.Recordsource = YourFormQuery or YourFormSQL
Forms!YourListBox.RowSource = YourListBox or YourListBoxSQL
Forms!YourComboBox.RowSource = YourComboBox or YourComboBoxSQL
Do this for any sub form as well. It should save a lot of time at design time.
Bill
Remove references from the property window to recordsources in you form and rowsources in listbox's/combo's .
In the form's on load event your code should look something like this.
Me.Recordsource = YourFormQuery or YourFormSQL
Forms!YourListBox.RowSource = YourListBox or YourListBoxSQL
Forms!YourComboBox.RowSource = YourComboBox or YourComboBoxSQL
Do this for any sub form as well. It should save a lot of time at design time.
Bill
- Status
Similar threads
- Locked
- Question
