Return current date on Lost Focus or On Exit

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
 
S

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date stamp on exit 4
Using IIf on a date field to return the result of an expression 5
Focus Question 2
Return the current date in a field on a form 5
Combine date and tim 1
Macro to act on current record 12
Access SendKeys Action in MS Access 2003/2007 0
Access 2003 - Macro Output File with current date 2

Top