Simple enough to test. Try Edgar's code in post 3 and see what happens.
I thought I could pass a return value from my error checking sub to the "On Click" event that saves the record, but you can't return values from a Sub.
Put your validation code into a function and return a boolean.
Then you can use
Code:
Cancel = YourFunctionName
but you can't return values from a Sub.
You can, sort of, but a function is better suited.
Code:
Sub SubOne()
Dim x As Integer
x = 12
SubTwo x
Debug.Print x
End Sub
Sub SubTwo(ByRef x As Integer)
x = 100
End Sub
If this helped, please click the star * at the bottom left and add to my reputation- Thanks