Disallow New Records but allow edits to existing records

Disallow New Records but allow edits to existing records

Post by TG9yYWxlZ » Tue, 31 Jul 2007 12:06:00


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
 
 
 

Disallow New Records but allow edits to existing records

Post by Rick Brand » Tue, 31 Jul 2007 12:14:55


Ahem... Check the AllowAdditions property : )

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com