What is wrong with the SetValue action?

[scottm91]

I have a simple macro (well, should be anyway) where I have a combo box that sets the value of an unbound text box that is then referenced by other controls in that and other forms. It worked fine last night. Choose an option, it sets the value, and all the references are fine. Now - after simply closing it last night and opening it this morning - it doesn't work. It won't update the unbound control and therefore none of my references work. And I've been getting a yellow "caution" type sign in my macros for all of my SetValue lines, yet clicking on it or hovering on it does nothing. What is going on with the SetValue action??

 

[scottm91]

Ok, figured part of it out. Apparently my computer thinks that the database that *I* created isn't trusted (only Microsoft.... AUGH!). I went in to Trust Settings and told it to trust my computer and my network, and I'm still getting the little error symbols in my macros. Why does Microsoft make this so difficult? I know what I'm doing, and I know how to do it, typically - I just don't know how to get Access to permit me to do it!