Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access
Resolved · Low Priority · Version 2003
Reply Tue 25 Nov 2008, 13:55Delegate Natalie said...
Natalie has attended:
Excel Advanced course
Access Intermediate course
Access
What is a conditional macro?
For upcoming training course dates see: Pricing & availability
RE: Access
Hi Natalie,
Thank you for your question.
A conditional macro runs a set of instructions when a certain condition is met.
E.g. If you had a set of sales figures, you could say that if the sales figure > 200, then show a Message box saying "Well Done". The condition being the field > 200 and the action being creating a message box. Then you can attach the macro to the Sales Value field and tell it to run when that field has been updated or run it on the current values in that field.
I hope this answers your question.
Regards
Simon
|