J
Johnson
Will someone tell me how to use a macro in Access 2000 to set the date in a
form field when the macro is run. Thanks in advance.
form field when the macro is run. Thanks in advance.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell [MVP]
Use the SetValue action. To provide more info, you'll need to tell us more
details.
details.
J
Johnson
I would like to have a checkbox on a form that when checked the current date
and time is inserted into a field on the form.
Thanks
and time is inserted into a field on the form.
Thanks
K
Ken Snell [MVP]
Put the macro on the AfterUpdate event of the checkbox control.
The macro's actions would be this:
Action: SetValue
Item: [NameOfTextboxControlOnForm].Value
Expression: IIf([NameOfCheckboxControlOnForm].Value=True,Now(),Null)
The macro's actions would be this:
Action: SetValue
Item: [NameOfTextboxControlOnForm].Value
Expression: IIf([NameOfCheckboxControlOnForm].Value=True,Now(),Null)
J
Johnson
Beautiful, thanks for the help.
Ken Snell said:Put the macro on the AfterUpdate event of the checkbox control.
The macro's actions would be this:
Action: SetValue
Item: [NameOfTextboxControlOnForm].Value
Expression: IIf([NameOfCheckboxControlOnForm].Value=True,Now(),Null)
--
Ken Snell
<MS ACCESS MVP>
Johnson said:I would like to have a checkbox on a form that when checked the current
date and time is inserted into a field on the form.
Thanks