Is it possible to establish a user-defined default value for a form? I have a form with a textbox where a weekly fuel surcharge (FSC) is entered as a percent value. This value may (or may not) change every Monday afternoon. Right now a manager gets this value from the Department of Energy and must open the form in design view to change the default value of the textbox. Might there be some method of accomplishing this without allowing design-view access? (We had some "issues" with that). Considering the limited security issues with Access, I also wondered if there might be some trick to only allowing the manager to make this entry. We discused issuing a "memo" each Monday afternoon to the operators, but found that even with this FSC notice there was the occational entry error due to keying or the failure to check the current FSC.
Any help gretly appreciated!