Update Checkbox

[O....]

I would like to update a checkbox once a Date as been entered in my date
field on a form.

 

[Larry Linson]

I would like to update a checkbox once a Date
as been entered in my date field on a form.

You can accomplish this with either a macro or VBA code in the AfterUpdate
event of the TextBox containing the date.

Larry Linson
Microsoft Office Access MVP

 

[Jeff Boyce]

Does this mean you want to have BOTH a date and a checkbox that "mean" the
same thing?

Usually this isn't necessary (or even a good idea) in a well-normalized
relational database.

Regards

Jeff Boyce
Microsoft Access MVP

 

[Armen Stein]

Does this mean you want to have BOTH a date and a checkbox that "mean" the
same thing?

Usually this isn't necessary (or even a good idea) in a well-normalized
relational database.

Well, it depends on the desired design. Sometimes we have a date
*and* a checkbox. For example, we might want to record the completed
date of something plus the fact that it is complete.

However, a record might be complete but the complete date is unknown.

So, if they enter a date, we automatically checkmark the box. But the
box can be checked without a date.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com