 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / March 2008Display of Set Value Macro
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).  SignatureChad Which event is running the SetValue action macro? SignatureKen 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 [quoted text clipped - 12 lines] > 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; SignatureChad > Which event is running the SetValue action macro? > [quoted text clipped - 14 lines] > > immediately. (Macro where if I check yes, the macro copies a result in > > another control). 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? SignatureKen 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 [quoted text clipped - 23 lines] >> > immediately. (Macro where if I check yes, the macro copies a result in >> > another control). |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.