Help with a field

  • Thread starter Thread starter loki
  • Start date Start date
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,
 
in the proporties of the field on the form find the
property (Default) and in it put Now()
 
I didn't know it would work with out adding the field to
the form. That is pretty cool.

Thank you,
 
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
 
Back
Top