Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Denying new records/Allowing Updates

Status
Not open for further replies.

tmcminn

MIS
Jun 17, 2008
12
US
Is there a way to limit a table allowing updates but not adding new records in? Ideally we would like to throw an error when a new record (item) is scanned into the database. I have been searching for two days and about ready to lose my mind!
 
At this point if a form or event is what we need to trigger some code, that is great. It's just the end result we need.
 
You can do a great deal with forms, including setting AllowAdditons to false. Other options are AllowDeletions and AllowEdits. You will find these properties on the form's property sheet (design view).
 
Wow, guess I posted this in the wrong forum then. Thanks so much, it worked of course!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top