Auto fill another field after entering date

  • Thread starter Thread starter RichardS
  • Start date Start date
R

RichardS

I have a field called Inactive Date which users type in
the date the account becomes inactive. What I would like
to do is have it so once a date has been entered into that
field, it will automatically put todays date and time [by
using now()] in another field called Completion Date. How
would I go about doing this? I apologize if this is
pretty basic, I am just not savvy in Access. FYI, I am
using Access 97.

Thanks,
Rich
 
Rich,

While in form design view, select the Inactive Date control, show the
properties window, select tab Events and locate the After Update event. Put
the cursor in it and click on the little button with the three dots that
appears on the right hand side of the selected property, then select Macro
Builder. You will be taken to the Macro design view and prompted to give a
name to save the macro under; give something meaningful that will make sense
later. Then go to the first line and type "SetValue" (without the auotes) in
The Action Column; tab to the next column, and notice the small window with
the two arguments at the bottom left hand corner. In the first one (Item)
type in the name of the control on the form that you wish to put in the
current date and time (Completion Date). In the second one (Expression) type
in "Now()" (without the quotes). Save and close the macro, and save the
form. You are done!

HTH,
Nikos
 
Nikos

I have a date field (combo field) and would like to have a selection to auto populate today's date. How can I use your macro to accomplish what I'm try to achieve.

What property should be listed on the combo field and what type of event control should the macro be listed under

Thanks,

Bill
 
Bill,

You're losing me... your original post made sense, and my answer was on
that. This one is not clear; is this different to what you described in the
first one? If yes, pls try to explain including control names and types.

Nikos

Bill said:
Nikos,

I have a date field (combo field) and would like to have a selection to
Click to expand...
auto populate today's date. How can I use your macro to accomplish what I'm
try to achieve.
What property should be listed on the combo field and what type of event
Click to expand...
control should the macro be listed under?
 
Back
Top