Timestamp Checkbox

[johnsqftwr]

Hi All,

I have a form logging problems and when the problem is resolved I have a check box which needs to be ticked.

The form is bound to a table.

When the check box is ticked I need a timestamp to be entered in the underlying table timestamp field.

Any help greatly appreciated.

Regards

John

 

[namliam]

Use the "on click" event of the check box to add your date to the table...
Easiest is to put the date field hidden on the form... then simply fill the needed date on the form using something like:
Me.YourDateField = Now()

Good Luck

 

[johnsqftwr]

Thanks for your prompt reply.

I am OK with the hidden field but am struggling with the on click event.

I have:

Private Sub Resolved_Click()

End Sub

The field that needs updating is:
tblIncomingCallLog.DateTimeResolved

Many thanks

 

[namliam]

then simply fill the needed date on the form using something like:
Me.YourDateField = Now()

So that would make.... Assuming you have said field on your form:
Me.DateTimeResolved = Now()

 

[johnsqftwr]

Many thanks for your help. So simple when you know how