checkbox to insert date

[efk0107]

Hi, I need to have a checkbox insert Now() into a field, when the checkbox is checked. This is to denote when a record has been updated to facilitate synching with remote data. Typically the checkbox will be False, but when the record is updated, we need to insert the current time and date. If the record is updated again in the future, we will then need to update the date/time stamp. Any help would be appreciated. I am weak in VB so specific answers would be most beneficial. Thanks, frank

[RuralGuy]

Why not just use the BeforeUpdate event of the Form to TimeStamp the record?

[efk0107]

We are constantly opening this form, but need to timestamp the record only if changes are made. Changes may be made on the remote end so we need to distinguish the most current record when syncing.
.

[RuralGuy]

You *ONLY* get a Form BeforeUpdate event when the Form is Dirty, meaning something on the Form is different than what is in the table.

[jmbreland]

What if (this is my situation) you want the date/time field to update ONLY if the checkbox is changed from FALSE to TRUE? (In other words, I don't want other changes to the record to result in a date/time update).

[orange]

Please provide more details and perhaps an example. Your requirement is NOT clear (to me).
Why do you need a checkbox? Seems Allan's approach is feasible.

[Missinglinq]

What if (this is my situation) you want the date/time field to update ONLY if the checkbox is changed from FALSE to TRUE? (In other words, I don't want other changes to the record to result in a date/time update).

Private Sub CheckboxName_AfterUpdate()
 
 If Me.CheckboxName = -1 Then
   Me.TimestampControl = Now
 Else 'This is needed if user mistakenly ticks the checkbox then unticks it
    Me.TimestampControl = Null
 End If 

End Sub

Linq ;0)>