Selecting combo value changes checkbox on other form

Robster

Registered User.
Local time
Yesterday, 22:08
Joined
Mar 13, 2014
Messages
60
I have form 1 that brings up a record, I then open up form 2 with that record details.
On the 2nd form I have a 'status' combo box with values 'OK', 'bad', 'unsubscribe'.
I want to change the value of a checkbox, 'Active', on the 1st form, 'Maildelivery', from true to false if the combo value is changed to 'bad'

Here's the code:

Private Sub cmb_status_AfterUpdate()

If Me.Status <> "OK" Then maildelivery.Active = 0

End Sub

Thanks in advance for your help.
 
Thanks Paul.
Used correct naming convention and it worked.
 

Users who are viewing this thread

Back
Top Bottom