tinyevil777
Registered User.
- Local time
- Today, 13:55
- Joined
- Dec 10, 2010
- Messages
- 137
Good morning all,
I have a field called "BookingStatuslbl". When the word "Cancelled" is entered into this field, i want a macro to run that will open a form to enter a Cancellation reason in.
I've entered the following code into the AfterUpdate event for the "BookingStatuslbl" field, but it doesn't do anything, it just tabs to the next field.
Any help/pointers would be greatly appreciated, thank you in advance!
Cheers,
Tom
I have a field called "BookingStatuslbl". When the word "Cancelled" is entered into this field, i want a macro to run that will open a form to enter a Cancellation reason in.
I've entered the following code into the AfterUpdate event for the "BookingStatuslbl" field, but it doesn't do anything, it just tabs to the next field.
Code:
Private Sub BookingStatuslbl_AfterUpdate()
If Me.BookingStatuslbl = "Cancelled" Then
DoCmd.RunMacro "CancForm", acNormal
End If
End Sub
Any help/pointers would be greatly appreciated, thank you in advance!
Cheers,
Tom