Check Box

[SheikMentor]

Good Day All
I want to enter a date that will automatically checked the check box. Using VBA
Kindly help me please

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[theDBguy]

Hi. If the date represents the checkbox or vice versa, then you probably don't need the checkbox at all.

PS. I am moving your thread/question out of the Introduction Forum.

 

[NauticalGent]

If you are using a form, use the After Update event for the control...

 

[Pat Hartman]

As theDBguy suggested, having two fields to represent the same piece of data violates normal forms and so you do not need to do it. Just check the data if you need to know if the "checkbox" is checked:

If IsDate(Me.SomeDate) then ---- is the same as If Me.SomeCheckbox = True Then

 

[CJ_London]

if you want to show a checkbox that shows whether a field has been completed or not you can use as a controlsource

=nz([SomeDate],0)

but it won't be updateable, use your datef ield for that

Or do you mean you want to tick a box and that will populate with the current date? If so then on the checkbox click event use something like

if me.checkbox=true then me.somedate=date() else me.somedate=null