Petr Danes
Registered User.
- Local time
- Tomorrow, 00:23
- Joined
- Aug 4, 2010
- Messages
- 150
It's been a long time since Access has managed to thoroughly stump me, but ...
I have a form called in dialog mode. It has numerous comboboxes, some of which have a huge number of records in their row source. I'm trying to use the technique of having a blank row source, then populating it only when needed, to reduce load time. The problem is that when I set the row source, it stays set after the form is closed. There is no warning about saving changes to the form, and even when I close it while specifically using the AcSaveNo option, it gets saved anyway. When I manually clear the row source and save it, everything is fine, until I run it again. Then, every combo that has its rowsource set while running stays set again.
I even added code to specifically cycle through all combos on the form and clear them in the form's close event. No luck, they still stay set.
What the **** do I have to do to make the row sources stay empty?
I have a form called in dialog mode. It has numerous comboboxes, some of which have a huge number of records in their row source. I'm trying to use the technique of having a blank row source, then populating it only when needed, to reduce load time. The problem is that when I set the row source, it stays set after the form is closed. There is no warning about saving changes to the form, and even when I close it while specifically using the AcSaveNo option, it gets saved anyway. When I manually clear the row source and save it, everything is fine, until I run it again. Then, every combo that has its rowsource set while running stays set again.
I even added code to specifically cycle through all combos on the form and clear them in the form's close event. No luck, they still stay set.
What the **** do I have to do to make the row sources stay empty?