Screen jumps around when moving between forms

[NeilT123]

I use coded buttons to move between the different forms in my database. All the forms are a similar design and colour and all open as maximised.

I have bought a new screen and now when I move between the forms there is a lot of jumping around as one form opens and the other closes.

The typical code would be

Private Sub btnGoToPrintReports_Click()
DoCmd.OpenForm "frmSboardPrintRpts"
DoEvents
DoCmd.Close acForm, "frmSboard", acSaveYes
End Sub

Does anyone have any hints, tips or ideas on what I can do to improve the situation?

 

[Ed2020]

Try:

Private Sub btnGoToPrintReports_Click()
DoCmd.Echo False
DoCmd.OpenForm "frmSboardPrintRpts"
DoEvents
DoCmd.Close acForm, "frmSboard", acSaveYes
DoCmd.Echo True
End Sub

DoCmd.Echo False turns off screen updates. I'd recommend adding an error handler to turn them back on as well, otherwise a runtime error will result in what appears to be a hung application.

Ed Metcalfe.

Please do not feed the trolls.....

 

[TheAceMan1]

How are ya NeilT123 . . .

[blue][purple]I have bought a new screen[/purple] and now when I move between the forms there is a lot of jumping around as one form opens and the other closes.[/blue]

I assume you mean you bought a [blue]new monitor![/blue] If thats the case, you have a hardware problem!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886