Help with a field

L

loki

Hello All,
I am new, and sorry if this post comes up twice. I don't
think the first one made it.

Anyway.

I have created a database, and one of the fields that I
have input into a table I need to ajust.

Date Time is the Field. What I am looking for is to
have the Date Time Field automatically populated when
adding a new record in my form.

Currently Date Time is just a blank field for the users
to update. I do not want to rely on the users updating
this field or making it is required field to fill in. I
just want the record to be Date Time stamped so to speak
when each new record is created.

I am thinking that maybe I would go to expression builder
to do this on the properties of the control object in the
form. But I do not know exactly what to put here or if
this is the right place to start.

Thank you in advance for your assistance.

Loki,
 
E

estewart

in the proporties of the field on the form find the
property (Default) and in it put Now()
 
L

Loki

I didn't know it would work with out adding the field to
the form. That is pretty cool.

Thank you,
 
G

Guest

Hello,
Why not use the date/time function now()in a pop up
window? This returns the current date and time. However,
you must refresh the date and time. Hope that this helps
Eduardo
 
Top