Another Date Question

[Doc94]

I have a form that uses a query of an underlying table as it's record source. I have a date/time field as follows:
Arrival Time 09/02/03 16:33
I use an input mask as follows
99/99/00\ 00:00;0;*
Now to the problem- to speed up data entry (since my IT department can not generate an interface for me) I want the date part to default to the current date and the time part of the field left to be entered. Any ideas on how to do this?

 

[SQLBI]

Doc,

In your form, set the default value of the control via the properties dialog to =Now()

Then, when the form opens, if there is no value for that record, it will default to the current date and time.

Hope this helps.

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk

 

[Doc94]

Leigh-
I appreciate the iput but that is not exactly what I want to do. I need only the date to default while the time remains an enterable field.

 

[Nowell]

Hi,

You could think about splitting the date into one field and the time into the other, then you can use the date() function to store the system date and the user can manually write the time in the other field.