Full Version: Lock record after input ?
UtterAccess Forums > Microsoft® Access > Access Forms
bakersburg9
Is there a way in code to have the record locked after input ? I have a form set up that I only want users adding new records to - the only reason is that I don't want them accidentally overwriting a record they've already input - actually, it would be better if I could have an error message pop up if they were about to alter a record.
But if I can't do that, I would at least like some way where the record they input via my form was locked, so they would be forced to click the 'ADD RECORD' button every time they went into the form.
R. Hicks
Make the form Data Entry only .. by setting the Data Entry property for the form to Yes ...
DH
bakersburg9
Ricky - Thanks so much !
R. Hicks
No problem ... frown.gif
DH
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.