date stamp

  • Thread starter Thread starter AJ Raiber
  • Start date Start date
A

AJ Raiber

Is it possible to have a yes/no checkbox cause a date
field next to it to update when it is checked? I would
imagine this should be possible, but I do not know coding
well enough to manipulate it in this way, yet. Thank you.
 
AJ Raiber said:
Is it possible to have a yes/no checkbox cause a date
field next to it to update when it is checked? I would
imagine this should be possible, but I do not know coding
well enough to manipulate it in this way, yet. Thank you.
Click to expand...

In the AfterUpdate event of the CheckBox...

If Me![CheckBoxName] = True Then
Me![DateField] = Date() ' or Now() if you want time included.
Else
Me![DateField] = Null
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date stamp 1
date stamping a record 10
New User - Time, and date Stamp 6
addind date stamp 0
Using Form to input multiple field to table at once 1
Inserting Date/Time stamps 6
Time Stamp 2
Null Value 3

Back
Top