question about time

[didacticone]

hey i was wondering is it possible that when a form opens it inserts the current time into a field called start time on my table... and when they click the finished button on my form it inserts the current time into a field on my table called end time... ive gotten it to work ut its inserting the same time in both fields... if anyone can help that would be great thanks...

[missinglinq]

Your actual intent here is a little unclear. You don't insert anything into a field on a table. You insert data into a field in a record on a table.

Do you want the Start Time/End Time inserted into all new records, when they're first created? What do you want to happen with these times if you go back and edit a record?

You might also post the code you're currently using for both of these events.

Linq ;0)>

[puppydogbuddy]

Hi Justin,
On your form, you need four textboxes as follows:

Any of the below that you want filled in when record created, place in default value property without the = sign; otherwise place in control source property as shown.


txtStartDate bound to expression>>> = Date()
txtStartTime bound to expression>>> = TimeValue(Now())


txtEndDate bound to expression>>> = Date()
txtEndTime bound to expression>>> = TimeValue(Now())