You could use a macro built into the form, or the other option is to use Access user account control - if you choose this option make sure u are VERY careful and backup your database in a different location beforehand, as from past experience...you can lock urself out of the database and then have to build another!
Hope this helps