Locking cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am in the process of creating an access database i have the main form
which different users will use. i have set a "finished" command button which
i have set a macro to save,gotonewrecord and exit what i would like to know
is is there a way of setting access to lock that complete record once that
button is clicked so the useers cannot edit previous records in the form

as usual appreciate any help
thankyou
 
You could add code to the "on current" and "on open" events of your form.
It would need to contain an "if" statement to test the checkbox. "If" the
box is checked, "then" you would set the "locked" property for the various
controls on the form to "true".

The on open would do this when the form is first opened. The "on current"
triggers as you move from one record to another.

Rick B
 
Back
Top