Uncheck 3 checkboxes on a form if all are true
I have this code in an onclick event of a command button on a form but it isn't working. In a test record all three checkboxes are true. Clicking the command button should change them to false.
Why wouldn't this be working?
--Steve
If Me.chkbxEmailList = True And Me.chkbxMailingLabel = True And Me.chkbxFaxList = True Then
Me.chkbxEmailList = False
Me.chkbxMailingLabel = False
Me.chkbxFaxList = False
End IfWhy wouldn't this be working?
--Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Robert Sherman
If what I mentioned above doesn't help, are those checkbox's NAME property the same as the name of the field they are bound to? It''s been a while, but I seem to recall a possible issue around that scenario.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What I found was code that was turning them all true again when the form was re-opened. I'll award points to all that contributed.