I'm working on a project using Access 2007. This db is in .mdb format to allow for assigning user permissions, etc.
On one form I have a macro ("m_new") set to run OnLoad, which is basically just a GoToRecord command taking the form to the NEW record.
When I log in from the 'USER' group I receive an error saying I am "not allowed to go to that record."
I'm certain this has something to do with the macro permissions for those in the USER group, but I've tried everything and can't get it to work.
Any thoughts?
Thanks!
eli