Redraw Question ...

[TheBionicOrange]

I've got an SSTAB control with an array of comboboxes on it.
When I click a button the combobox values change.
This is determined by the results of a recordset.
Sometimes it can be a bit slow, and you can see bits and pieces redrawing before others.
The SSTAB control, and Combobox controls don't have a REDRAW option I can turn on and off (like a flexgrid for instance).
Anyone suggest a clever alternative ?

Maybe power the monitor off and then back on ! ha ha !!

(That was a joke).

[RhinoBull]

Shutting off monitor will work ... ... but I'd rather lock window while updating values:

Option Explicit
 
Private Declare Function LockWindowUpdate Lib "user32" (ByVal hwndLock As Long) As Long
 
'usage:
LockWindowUpdate Me.hWnd
'do your stuff here
LockWindowUpdate False

[TheBionicOrange]

Well I tried that ... but it didn't work. You can still see values changing as the listindex property gets altered in the listboxes.
I'll have a play around a bit.

[bushmobile]

how about:

lockwindowupdate
hide controls
update them
show controls
unlock window

[RhinoBull]

Well I tried that ... but it didn't work. You can still see values changing as the listindex property gets altered in the listboxes.
I'll have a play around a bit.

That doesn't sound right ... sorry ... The whole point of "locking window" is to hide all changes until they done.
How did you do it?

[TheBionicOrange]

Rhino : Pretty much exactly as you said, i.e.

LockWindowUpdate Me.hWnd
---> I did all my changes here
LockWindowUpdate False

BM : I'll try that now.

[RhinoBull]

Strange... You don't have any DoEvents - it shouldn't have any effect but ...?

[TheBionicOrange]

No I don't.
I don't get it either ?!?!
Ah well.