Disallow New Records but allow edits to existing records

G

Guest

I want to allow users to make some CHANGES ONLY to records via a continouos
form. I do NOT want them to add new records however. I have tried
changing several properties and used "allowedits" but that allows users to
both add new records and change records.

Is there another property I can use or another way of doing this?

The primary key for the table (where the recordset is drawn from ) is
autonumber. I am working in Access 2000.

Thanks-
Loralee
 
R

Rick Brandt

Loralee said:
I want to allow users to make some CHANGES ONLY to records via a continouos
form. I do NOT want them to add new records however. I have tried
changing several properties and used "allowedits" but that allows users to
both add new records and change records.

Is there another property I can use or another way of doing this?

The primary key for the table (where the recordset is drawn from ) is
autonumber. I am working in Access 2000.
Click to expand...

Ahem... Check the AllowAdditions property : )
 

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

Create new record but do not allow update of old records 1
Need to add revised records as new... 2
Add new records 2
Adding records to subforms 2
Controlling Edits 2
How to Change Allow Edits to No But Use Look-Up Combo 3
Copy old subform records to new Form's subform 1
Insert Matching Records to different table 3

Top