Slow Synchronizing Combo Box

[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

 

[John Spencer]

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.