My cancel button macro works.
When I click "cancel" on my form it gives the normal cancel dialog but it
just has an okay button on it, no words saying "cancel". There is no other
option, when you push cancel it cancels but it gives the dialog box and lets
you push the okay button. I think that is fine but it should say "cancel".
I looked on the properties window:
cancel = true
default = true
enabled = true
take focus on click = true
tab stop = true
also the caption is "Cancel"

I tried this on the cancel macro.

Public Sub cmdCancel_Click()
Unload Me
vbCancel
End Sub

do you know how to make it say "cancel"?

thanks,