Zoom Box window handling

[Guest]

When I run this command I get a window with Ok and Cancel buttons

DoCmd.RunCommand acCmdZoomBox

How do I tell which button was pressed?

 

[Stefan Hoffmann]

hi,

When I run this command I get a window with Ok and Cancel buttons
DoCmd.RunCommand acCmdZoomBox
How do I tell which button was pressed?

This information is useless, but you can determine the change by
tracking the values of your controls.

E.g.

Dim OldValue As Variant

OldValue = Screen.ActiveControl.Value
DoCmd.RunCommand acCmdZoomBox
If OldValue <> Screen.ActiveControl.Value Then
'Changed...
End If


mfG
--> stefan <--