Return current date on Lost Focus or On Exit

  • Thread starter Thread starter Somecallmejosh
  • Start date Start date
S

Somecallmejosh

Hello,

I have a form containing the following field names:
[KitReturned]
[PostedDate]

I would like to set up a Macro that fills the current date
in the [PostedDate] field upon exiting, or after entering
a date into the [KitReturned] field. I tried the SetValue
approach but was met with much resistance. Does anyone
have any ideas on how I can accomplish this? Thanks in
advance.

Josh
 
Josh,

A SetValue macro would be a good way to go here. This is normally
simple and straightforward, so if you need help you will need to be a
bit more explicit with the meaning of "met with much resistance".

However, if this is going into a new record, the easier approach would
be to use a Default Value for PostedDate.
 
Back
Top