Hi - i have a data entry form in Access with multiple combo boxes. The combo boxes include code to automatically drop-down any time they receive focus. It seems that Access is automatically refreshing the forms on a periodic basis which causes the combo box to automatically close at undesirable times. The user then has to click the combo box arrow to drop-down the box again to see the list of available records. Is there a way to disable the automatic form refresh process so that the combo boxes remain open until the user tabs to a new field/control?
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Disable Automatic Form Refresh
- Thread starter corycrum
- Start date
I don't believe there is an automatic refresh or requery of the form. I expect there might be some code that is running to do this.
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
missinglinq
Programmer
Actually Forms are refreshed automatically...at least through 2007. In that version, you can find it under Options - Advanced and then down under the Advanced Section. It defaults to 60 seconds but can be set to 0 (zero).
Hope this helps!
There's always more than one way to skin a cat!
All posts/responses based on Access 2003/2007
Hope this helps!
There's always more than one way to skin a cat!
All posts/responses based on Access 2003/2007
- Status
Similar threads