Form flicker during calcs

[swas]

Hi,

I have a few forms with various bound and / or calculated controls.

With some buttons / events, I need to process all records. I generally use

dim rs as dao.recordset
set rs=me.recordsetclone

do
rs.edit

....do crunching

rs.update
rs.movenext
loop

me.recalc
etc...

All code is working fine, except I seem to get form screen flicker. the more
detailed the manipulations, the more flicker.

Is there a more professional approach to editing data on forms? Should I set
form.visible=false for example?

Thanks in advance

swas

 

[Douglas J. Steele]

See whether setting

Application.Echo False

at the beginning (and

Application.Echo True

at the end) helps.

You might also have to issue a screen Repaint at the end.

 

[swas]

Doug,

It works perfectly.


Thanks

swas

See whether setting

Application.Echo False

at the beginning (and

Application.Echo True

at the end) helps.

You might also have to issue a screen Repaint at the end.