Password to enter data....

[Marcus H]

To change data on my field i would like the person to have to type in a password. EG if they wanted to change the cost price in the 'costprice' field from £10 to £12 they would type in £12 and then have to type the password for it to go through. Is there any way of implementing this? Any tips would be smashing. Cheers.

 

[llkhoutx]

Use VBA code: when OnEnter fires, save the original value, then when AfterUpdate fires to open a Password Window prompting the user for a Password. If the Password isn't entered after three tries restore the data to its original value. You could have one password for all or a password for each user.

 

[Marcus H]

How do i set up a password window to implement this......how do i assign lots of passwords so each user can have there own?? Thanks for any help again!