Date field

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a 'Date' field in a subform. Is it possible, if the
current day comes up automatically in that field, when an
user types in the next 'Text' field. IF YES, HOW?
 
Tom,

You shouldn't use 'Date' for a field name. Date is a reserved word and will
consequently give you a problem at some point.

To do what you want, put this code in the AfterUpdate event of the text field:

Me!NameOfDateTextBox = Date()
 
Tom,

In the next Text field's properties, set the On Change event to run a macro
with a SetValue action, arguments:
Item: Date field name
Expression: = Date()

HTH,
Nikos
 
Back
Top