Access 2010 Change Default Value for a Table field
Posted on 2013-01-05
I have some number fields in my table that have Default Values set in the Field Properties window. These fields and the default values in them are required as a minimum for every record saved.
Every now and then, these default values will need to be changed. The users of this database are not very technically savvy. I don't want them bumbling around in design view trying to change these values. I need a text box + button press way to change the default value for these specific table fields.
Is this possible?
My database is already built, so I am trying to avoid major changes.
Thanks in advance.