Time entry

[xcmav66]

I would like to allow the user of my form to enter a time, and have it bound to a date/time field in a table. What is the easiest way to do this? I saw a Microsoft Date and Time Picker Control, and that does pretty much what I want it to do, although its output is not what I want it to be and I can't seem to get it to display the current date as a default value. Thanks.

 

[dkinley]

Create a date field in the underlying table the form is bound to (do not use "Date" as a name but some variation of because it is a reserved word).

On the form, create a new control for this date field (to bind it to).

Set the default value of this control to: =Date().

That will place the current date in the field/control. You can then use the date picker if you wanted so the user can adjust the date.

-dK