Auto insert date & time on a form

[Guest]

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()

 

[Guest]

For date and time:

txtDate.Text = Now()

For just the date:

txtDate.Text = Date()

 

[Guest]

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

Regards

Chomp

 

[Marshall Barton]

For date and time:

txtDate.Text = Now()

For just the date:

txtDate.Text = Date()

Sandy, your VB is showing ;-)

In Access, if any code was needed, it would be the Value
property.