What are they using to change the data?
Use something like this:
Dim X as integer in the Declarations
Code:
Do Until X = 1
DoEvents
Loop
X = 0 'reset X
The Set X = 1 when the user click or type or does what they are supposed to do.
like this
Say the have to type in a text box...maybe look for then Enter key to be struck then X = 1...
or add a command button that enters/changes the data then sets X = 1...so on..
Just make sure that X = 1 is the LAST thing your code does...(if you set X = 1 then do code it will continue while the other code is trying to complete)
Hope this helps