Update Checkbox

  • Thread starter Thread starter O....
  • Start date Start date
O

O....

I would like to update a checkbox once a Date as been entered in my date
field on a form.
 
O.... said:
I would like to update a checkbox once a Date
as been entered in my date field on a form.
Click to expand...

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
 
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
 
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.
Click to expand...

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
 
Back
Top