Hi, I really need people who understand the 2010 Macro Builder and how to use Macros with "After Update" events.
MACRO BUILDER IS THE ONLY TOOL AVAILABLE IN 2010 WEB DATABASES. Please don't reply with a load of code and say you missed that bit.
I need to use it (2010 Macros) to create the style of "After Update" events that allow you to build cascade combo boxes. In the past I've done this with a little code, eg the Private Subs on this page:
http://www.fontstuff.com/access/acctut10.htm
The idea is (I hope many advanced users should be familiar with it, if not you can probably pick up the idea very easily): Two combo boxes: cboCountry; cboRegion. I select Mexico, After Update event then narrows the choices in cboRegion to the Mexican ones. If I change the record to have Country: Canada, this (via an "After Update" event) updates the contents of cboRegion with Canadian regions only, and pops cboRegion open to remind the user that now they've made a new choice with Country, they'll also need a new selection for Region.
Now, how to get this job done with Macros (eg in a Web Database where this is the only tool available)? Please tell me even if you think it is obvious.