Thread: Flickering Pages

Thanks heaps I have taken on your suggestion re the eror handling. It all works great.

Thanks heaps I have taken on your suggestion re the eror handling. It all works great.

You can use the echo method to turn off the screen refresh, and then turn it back on after your code is done. Fair warning: I strongly suggest having error handling such that if an error is triggered, your error handler will turn the echo back on. Otherwise you risk leaving echo off for the user's machine, which is exceedingly annoying.

You can use the echo method to turn off the screen refresh, and then turn it back on after your code is done. Fair warning: I strongly suggest having error handling such that if an error is triggered, your error handler will turn the echo back on. Otherwise you risk leaving echo off for the user's machine, which is exceedingly annoying.

Note also the 'flickering' might be due to the recordset requerying. I've never had to use any code to turn off any type of flickering (and wouldn't recommend it). Sometimes a Refresh command versus a me.requery versus a me.repaint makes a difference in the code. I did have problems once with flickering over a citrix connection for the users. I used unbound forms to resolve this along with changing citrix screen refresh...

Note also the 'flickering' might be due to the recordset requerying. I've never had to use any code to turn off any type of flickering (and wouldn't recommend it). Sometimes a Refresh command versus a me.requery versus a me.repaint makes a difference in the code. I did have problems once with flickering over a citrix connection for the users. I used unbound forms to resolve this along with changing citrix screen refresh...