Display of Set Value Macro

[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).

 

[Ken Snell \(MVP\)]

Which event is running the SetValue action macro?

 

[chad]

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

Which event is running the SetValue action macro?

--

Ken Snell
<MS ACCESS MVP>

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).

 

[Ken Snell \(MVP\)]

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>

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

Which event is running the SetValue action macro?

--

Ken Snell
<MS ACCESS MVP>

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).