Solved GotFocus for combo box (1 Viewer)

kobiashi

Registered User.
Local time
Today, 04:00
Joined
May 11, 2018
Messages
258
I've decided to deploy my backend into a MySQL server, and works well for the most part, but there is some issues with load times on some of the forms, so i need to quicken the form loads up, most of my forms are relatively fast in loading, but one of them has 10 combo boxes on it and this is causing the load time to lag, so i have read that you can use OnGotFocus on each combo box to reduce the load times, i have had a search but dont seem to be able to find much info on this and was wondering if anyone could point me in the right direction please, also ive read the OnGotFocus has a issue with popup forms, which the one im trying to reduce load times is a popup box.
 

kobiashi

Registered User.
Local time
Today, 04:00
Joined
May 11, 2018
Messages
258
ok so i think ive solved it, but just for clarity please could someone confirm


Code:
Private Sub TxtVehNo_GotFocus()
    [TxtVehNo].RowSource = "CbxQryVehicleName"
End Sub
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 20:00
Joined
Aug 30, 2003
Messages
35,158
That should work. Another option if the selections are relatively fixed is to load them into local tables when the app starts. It will slow down the start but speed up the dependent forms during use.
 

Users who are viewing this thread

Top Bottom