Slow Synchronizing Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Slow Synchronizing Combo Box:

Normally, I place the, “Me.Refresh†code, as shown below, for the following
four combo boxes, “serviceclassâ€, “prognameâ€, “locationâ€, and “eventname†in
the, “Got Focus†of the properties sections of each of their combo boxes.

However, it slows down when I, have, to use the, “Me.Refresh†in just the
second of the four combo boxes, in order for them to synchronize properly, it
works:

Private Sub progname_GotFocus()
On Error GoTo ErrLine
Me.Refresh
ExitLine:
Exit Sub
ErrLine:
Resume ExitLine
End Sub

While this does work; when I get to the second combo box to sync the next,
or third, combo box, it synchronizes much slower. It synchronizes slow, or
intensively enough that it blanks-out the whole form until it completes
synchronizing the next combo box.

Any ideas?

John
 
Have you thought of using Requery on the combobox(es) vice Me.Refresh.

ProgName.Requery <-- this refreshes/requeries ONLY the ProgName control

Me.Refresh on the other hand does a lot more than just the one control.
 
Back
Top