D
Dan
How can I lock a record after someone changes it in a form so that no more
changes can be made to that record. I have a database that tracks items as
either being in stock or out of stock. When we do inventory I would like to
lock a record so that it can not be change back in my form. So when I'm
doing inventory and an item is out of stock and a clerk clicks on the out of
stock button that record is locked and someone can not accidently go in
change it back. The only way I would like it to changed it was that I would
have to go into the table myself and change it or I create another form that
when the item comes in the person inventoring it will use this form to change
the item from out of stock to in stock.
changes can be made to that record. I have a database that tracks items as
either being in stock or out of stock. When we do inventory I would like to
lock a record so that it can not be change back in my form. So when I'm
doing inventory and an item is out of stock and a clerk clicks on the out of
stock button that record is locked and someone can not accidently go in
change it back. The only way I would like it to changed it was that I would
have to go into the table myself and change it or I create another form that
when the item comes in the person inventoring it will use this form to change
the item from out of stock to in stock.