Run macro from combo list

[Tareq_1993]

Hello Everyone

Please, I need to know the way, how to activate the macro by clicking on a choice from choices in the drop box? I've seen one in read templates of Office 2007, but I dun know how to make one like it.

I am using Access 2007

Please help me.

Yours, Tareq

 

[dbDamo]

You can do it by performing a check on the option selected from the list in the list controls BeforeUpdate (maybe OnChange?) event. Then if it matches the criteria you have set, set the macro to run.

You might also want to think about whether or not you want the macro to be run multiple times (user could keep changing selection from list)