Stop form opening and flash

[agibsonsw]

Hello. Access 2003.
I'm cancelling a form open event, but the form still opens, briefly causing screen-flash.
Is there a way to prevent this?
Thanks, Andy.

[HansV]

If you cancel opening the form depending on a certain condition, you could test this condition before opening the form, and only open the form if desired:

Code: Select all

If (certain condition) = False Then
  DoCmd.OpenForm "frmTest"
End If

[agibsonsw]

Hello.
That makes sense, but I was just demonstrating the Cancel argument when
someone noticed the screen flash. Andy.

[HansV]

If you open the form by itself and code in the On Open event sets Cancel = True, I don't think you can suppress the form briefly flashing.

[agibsonsw]

Thought that might be the case. Ta, Andy.