Conditional macros

Hello Peter,

Thank you for your question regarding conditional macros.

We are running a skeleton staff over the festive period, so we will do our best to answer your question shortly.

Regards,

Richard
Microsoft Office Specialist Trainer

Hi Peter,

Happy new year.

Please find attached the Access database with the conditional macro we discussed at the end of the course.

I have attached the macro to the On Current event of the form and the After Update event of the Discontinued checkbox.

When you create a new macro you have to click the Conditions and Show All Actions buttons to ensure SetValue is available.

Regards

Simon