Date field

[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?

 

[PC Datasheet]

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

 

[Nikos Yannacopoulos]

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