Is there somewhere in access where I can put in code or something to enter the date of that day (in DateActive) field when the active field is checked and enter the date in DateReleased field when the box is unchecked? see below.
To better explain. I have a user table and an Active Field. When we create a new user we Activate them (yes/no) checkbox. If we Activate him by a checkmark I would like the date of that day to be entered in the next field automatically (DateActive)
When the user is left us we wish to Deactivate them.... still leaving the initial date in the (DateActivate) field but now entering todays date in (DateReleased) field.
I am working with Access 2013
Field names
You may have to explain in detail. I am a newby....
Thanks for help
merv
To better explain. I have a user table and an Active Field. When we create a new user we Activate them (yes/no) checkbox. If we Activate him by a checkmark I would like the date of that day to be entered in the next field automatically (DateActive)
When the user is left us we wish to Deactivate them.... still leaving the initial date in the (DateActivate) field but now entering todays date in (DateReleased) field.
I am working with Access 2013
Field names
[Active]----- [DateActive]---- [ DateReleased]
yes.no checkbox----- Date field--------- Date field
You may have to explain in detail. I am a newby....
Thanks for help
merv
Last edited: