Detect when record has finished loading

[PeterWieland]

I am using DoCmd.GoToRecord to return a single record from around 300,000. Depending on where the record is the time taken to retrieve the record varies. If the code is allowed to continue, I get errors as the data is not ready. At the moment I use a timed delay to wait for the record to load, but that is not very elegant.

Is there a way to detect when the record has finished loading?

 

[RuralGuy]

Have you tried setting a success flag in the Current event of the form and then looping your code on DoEvents until the flag is set?

 

[PeterWieland]

Thanks RuralGuy, that did the trick!

 

[RuralGuy]

Glad to help.