Display of Set Value Macro

  • Thread starter Thread starter chad
  • Start date Start date
C

chad

Macro example: Condition- [Sat Score]="180+", SetValue- Item:[SatOpenB
Score], Expression:"180". this is used in a form. the purpose is to be able
to add the 180 with another field(control) to get a total for the 2 fields.

Problem: When I enter the 180+ in the Sat Score control and then tab to the
SatOpenB Score control, the 180 doesn't showup unless I either select Refresh
or close the form and reopen it.

I have other fields(controls) where I do this and the results are displayed
immediately. (Macro where if I check yes, the macro copies a result in
another control).
 
I enter the Number 180+ into the Text field (control): [Sat Score] and this
entry causes the macro to run, entering 180 into the Number field
(control):[SatOpenB Score]. The macro is attached to the [Sat Score] control.

A query then automatically adds the 180 in the Number field:[SatOpenB
Score]and another Number field:[SatUtilityB Score] to get a High Combined
Score;
--
Chad


Ken Snell (MVP) said:
Which event is running the SetValue action macro?

--

Ken Snell
<MS ACCESS MVP>


chad said:
Macro example: Condition- [Sat Score]="180+", SetValue- Item:[SatOpenB
Score], Expression:"180". this is used in a form. the purpose is to be
able
to add the 180 with another field(control) to get a total for the 2
fields.

Problem: When I enter the 180+ in the Sat Score control and then tab to
the
SatOpenB Score control, the 180 doesn't showup unless I either select
Refresh
or close the form and reopen it.

I have other fields(controls) where I do this and the results are
displayed
immediately. (Macro where if I check yes, the macro copies a result in
another control).
Click to expand...
Click to expand...
 
You have not identified the event that runs the macro. Open the form in
design view, click on the textbox, right-click and select Properties from
the menu, and then click Event tab in the Properties window. Which event has
the macro "assigned" to it?

--

Ken Snell
<MS ACCESS MVP>


chad said:
I enter the Number 180+ into the Text field (control): [Sat Score] and this
entry causes the macro to run, entering 180 into the Number field
(control):[SatOpenB Score]. The macro is attached to the [Sat Score]
control.

A query then automatically adds the 180 in the Number field:[SatOpenB
Score]and another Number field:[SatUtilityB Score] to get a High Combined
Score;
--
Chad


Ken Snell (MVP) said:
Which event is running the SetValue action macro?

--

Ken Snell
<MS ACCESS MVP>


chad said:
Macro example: Condition- [Sat Score]="180+", SetValue- Item:[SatOpenB
Score], Expression:"180". this is used in a form. the purpose is to be
able
to add the 180 with another field(control) to get a total for the 2
fields.

Problem: When I enter the 180+ in the Sat Score control and then tab to
the
SatOpenB Score control, the 180 doesn't showup unless I either select
Refresh
or close the form and reopen it.

I have other fields(controls) where I do this and the results are
displayed
immediately. (Macro where if I check yes, the macro copies a result in
another control).
Click to expand...
Click to expand...
Click to expand...
 
Back
Top