Darn Flickering

[mission2java_78]

I have a db system where I need to requery the recordset...and we all know when you requery you are brought back to recordset one unless you use some type of recordset clone and go back to the original record. Well this is what I do in my code...but I am experiencing a very slow movement back and WAY too much flickering of the screen along with the hourglass shutting on and off. I was advised to do the following:

Me.DataEntry = False
'stop the flickering on a requery
DoCmd.Echo False, "Executing Visual Basic Code, Please Wait..."
Me.Requery
'make sure we go back to the record that the user was working on because a requery takes
'us back to the first record

Me.RecordsetClone.FindFirst "[RecordID]= " & index & ""
Me.Bookmark = Me.RecordsetClone.Bookmark

'flickering done after the requery
DoCmd.Echo True

Using the Docmd.Echo was SUPPOSED to stop the flickering ... but this isn't the case I continue to deal with a very annoying flickering of the screen...
can someone help spot the problem ?

Jon

 

[Rich]

Isn't it
Application.Echo False

 

[Jeff Bailey]

From Help:

"The Echo method doesn't suppress the display of modal dialog boxes, such as error messages, or pop-up forms, such as property sheets."

Are you using a pop-up form?

Jeff

 

[mission2java_78]

Auto updates of the recordset. Many users want to see updates almost instantly..the only way I could see these updates is to requery..right?
Jon