Problem With SetValue, but Only On Certain Forms

[probablyjoel]

I'm an access n00b and am having issues with the SetValue macro.

Basically, my database is for HR and uses a series of forms to enter a new hire, and to export this new hire to excel for a data upload. The weird thing is that it worked before, then all of a sudden, it gave me error 2950 while trying to run a macro which had a few SetValue functions.

I went to another form to see if that one worked w/ SetValue (because the database is trusted in my system), and it did. So my problem is that I'm receiving error 2950 (trust issues) in one form, but not receiving the same error, from the same function, on another form.

Our IT guys are stumped and, needless to say, I am too.

Any help would be greatly appreciated.

[June7]

Maybe convert macros to VBA? Unless this is a web db.

[probablyjoel]

Well, the unfortunate thing is that I don't know VBA and I need to keep this database in a format which will easily be updated by me.

This is just so weird though, as I was getting the above outlined issues on Friday, but today, everything is working just fine. I guess this is sorted out for the time being .

Thank you for your suggestion though!