Auto insert date & time on a form

[The Chomp]

I am sort of new with this.....

I am creating a data input form and I want to capture the date&time the new
record was entered. What would be the best way to do this.

I have created a date&time (general) field in the table

Thanks All
Chomp

 

[Marshall Barton]

I am sort of new with this.....

I am creating a data input form and I want to capture the date&time the new
record was entered. What would be the best way to do this.

I have created a date&time (general) field in the table

Set the field's DefaultValue property to Now()

 

[Sandy]

For date and time:

txtDate.Text = Now()

For just the date:

txtDate.Text = Date()

 

[The Chomp]

Thank you very much Sandy & Marshall. This works like a charm

Regards

Chomp