Auto filling date field, by checkbox field (1 Viewer)

[QueryStumped]

Hello....I am needing to know how to have a date field automatically populate with the day's date once a checkbox is checked. Please and Thank You!!

 

[isladogs]

Add code to the checkbox click event. Something like

private sub chkbox1_click()

If me.chkbox1=true then Me.Datecontrolname=Date()

End sub

 

[QueryStumped]

New in creating events for fields on forms. question, so in the design view of the form where the 2 fields are, I will right click on the date field, under properties and add under the all tab?

 

[QueryStumped]

Thank you for your quick response, i really appreciate it. Learning as i go, in my new position.

 

[isladogs]

New in creating events for fields on forms. question, so in the design view of the form where the 2 fields are, I will right click on the date field, under properties and add under the all tab?

No.
In design view, click the checkbox control then go to the property sheet, click the Event tab ...On Click event.
Select Event Procedure then click the ellipsis button with 3 dots (AKA browse button) to open the code window at that procedure.
Enter code similar to that in my first reply but using your control names

 

[pbaldy]

A visual of what Colin is describing:

http://www.baldyweb.com/FirstVBA.htm

And the second example here if you want to undo the date if the user unchecks the box:

http://www.baldyweb.com/ConditionalVisibility.htm

 

[QueryStumped]

Thank you Colin and Paul, I really appreciate your help. I absolutely love this website, very positive feedback since I joined. Programming is not my forte. But I am learning, and it worked. Thank you all!

 

[isladogs]

You're welcome. Remember we were all beginners at one point.

Thanks to Paul for adding 'flesh' to my explanation.