Is there a way to only allow editing on new records?

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

I have a form whose Record Source is a query involving three tables.
I want the user to only be able to edit some of the fields normally, but
all of the fields for a new record (Navigation Buttons).
Can this be done easily?
 
In the Form's OnCurrent event check to see if you are at a new record (If
Me.NewRecord Then...). If you are, then set all the controls' locked
property to false, if you aren't then set the locked property of the
controls you don't want them to be able to edit to true.
 
Back
Top