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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

blank form, can't insert new record 11
Continuous Forms - Insert New Record 4
I can't edit existing records, only add new 2
Access Automatically Send a notification email once a record is added 0
Editing Records 2
Duplicating records 3
Copy record info into new form 0
DMax on existing record to increment serialized # fails 1

Back
Top