Create new record but do not allow update of old records

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hi,
I have a table displayed in a form.
How can I let the user insert new records but not allowingthem to uodate
already existing records,
Many Thanks,
Dan
 
Why not use the form's data properties (data tab).

Set the 'Allow Edits' property to False, while ensure that the 'Allow
Additions' is set to True
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
You must log in or register to reply here.

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

Creating a new record in only one table of underlying query 4
Record insert/delete anomaly 0
Save New Record that is not dirty 2
Inserting new record problem 2
How do evaluate tables and insert record if none exist 6
Access Automatically Send a notification email once a record is added 0
Copy old subform records to new Form's subform 1
Add New Record 1

Back
Top