Date and time field

[Wayne Cramer]

I have a form for table data enrtry. Data entry using this form will take place during a phone conversations with customers. One of the fields I would like to capture is the date and time of the call. If I use the Now() function the date time changes and does not fill in the field on the table. Is there a way to autmatically capture the date and time at the time of the call?

 

[boblarson]

One way would be to put a button that lets the user insert it:

Me.YourTextFieldName = Now

Or, you can insert it in the Before Update event (same syntax).

 

[Wayne Cramer]

Bob,

The button works great! Thanks.

 

[boblarson]

Glad we could help

 

[missinglinq]

And if you're re-visiting these records ( and the comment about the time changing sounds like you do) and you don't want some doofus hitting the button again and changing the date/time, use this construct

If Me.NewRecord Then 
  Me.YourTextFieldName = Now
End If

Linq