I'm following this guide at MSDN, Office 2010 Developer Training Course > Access 2010 > Building Solutions with Access 2010 Lab using the Contacts Web Database template.
I'm at Exercise 4: Creating a Data Macro and for whatever reason my macro is not working at all.
I created the macro and confirmed it matched to the guide and I had no errors when I saved it, so that has to count for something.
The macro is suppose to be invoked when the 'Status' variable is "Offer Outstanding" more than once in the database.
Yet I can select it multiple times without any instances of the macro displaying any warning message as it should.
Should mention, the "Offer Outstanding" is from a drop down list, so it's not that I'm mistyping it multiple times.
The guide mentions to test the macro twice, one against the table and once against the form. It doesn't work for either and unfortunately the guide assumes they work, and doesn't suggest anything if it doesn't.
I even tried enabling all macros (dangerous), and restarting Access with no success. I'm still learning Access and this is my first attempt at defining a macro.
This is the macro, sorry didn't know how to copy just the code from Access so I took a snapshot.
Thanks
Mike