I use Access 2002. I created a form that updates when a patient gets a Flu Vaccine.
I would like to simply check a checkbox and the form should take todays date and store it in the field FLUDATE from table FLU.

I have the other fields from the table FLU on the form and they update properly.
FLUDATE is defined as a "shortdate" .

On the form, the ControlSource for the Checkbox is FLUDATE. ...