Denying new records/Allowing Updates

[tmcminn]

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!

 

[Remou]

Do you mean without using a form?

 

[tmcminn]

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.

 

[Remou]

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).

 

[tmcminn]

Wow, guess I posted this in the wrong forum then. Thanks so much, it worked of course!