Public Function to do a Me.Undo when called from a Form Control? (1 Viewer)

[Steve C]

I want to call MyPublicFunction from a Control Before Update event,

MyPublicFunction()
If MyGlobalBoolean True then
MsgBox “Some message.”
Me.undo
End If

Of course, MyPublicFunction doesn’t know the “Me” in Me.Undo.

How can I pass the "Me" to MyPublicFunction so it knows what to undo?

Of course, a Private Function will work but it would have to be repeated many times and so would be tricky if changes are needed in the future.

Thank you very much

Steve C

 

[JHB]

Call it with the Me.

  Call MyPublicFunction(Me)

Public Function MyPublicFunction(Theform As Form)
  If MyGlobalBoolean True then
    MsgBox “Some message.”
    Theform.Undo
  End If
End Function

 

[pbaldy]

Another option might be using ActiveForm.

 

[Steve C]

Thank you very much JHB & pbaldy.

two elegant solutions which I would not have figured out on my own - thanks again.

Steve C