MS Access 2007 can I allow a user to lock records in a datasheet after updating
Posted on 2011-02-24
I have a problem that I hope someone can assist me with.
Within Access 2007 I have a form[Contractors], within that form is a subform[SubContractors] and within the subform is a datasheet form[Payroll].
The Payroll datasheet consists of the following fileds; date, gross, materials, tax, fee, net.
At present the user can enter data into the fileds and if they need to make an adjustment at a later date they go back to the form and edit any fields they require. I have this already setup and working fine.
However, what I would really like to achieve is the following;
When the user is satisfied the data they have entered into a row is correct, could I put an extra field in the datasheet or a button within the form that allows the user to lock the row in question. I must point out that once the row is locked it must not able to be unlocked.
Is this possible?