randomtangent
New member
- Local time
- Today, 15:47
- Joined
- Dec 5, 2019
- Messages
- 5
Hi, I have a form that has checkboxes for the different ways a customer uses our services and I would like to have it update a field with the current date when it is checked. That way we can later run reports showing that a customer found us one way and then started using another service of ours 3 months later or something. I have the checkboxes and the date fields in the customer table. I have the checkboxes on a form linked to a different table (for orders) and I understand I need to use VBA on the "onclick" event for the checkbox on the form. I just don't know what the VBA code should say. I have only ever used VBA by googling what I need to do and then pasting code
Hopefully this makes sense. Thanks for the help!
Hopefully this makes sense. Thanks for the help!