Hi, my database is in a trusted location, but I am unable to use macro actions such as SetValue, they just don't appear in the action list. I am using Vista and Access 2007.
I don't have 2007 in front of me, but if you get the macro in design view, you should see a button on the ribbon that says something to the effect of "Show All Actions".