How to disable Add New Record in the code?

[perryche]

All,
I know I can do it in a form, but, I want to ask the user to
put in their ID, if ID = 99999 for example, the user will be able to
edit the records already in the DB, but not add a new one. How to
accomplish that by using CODES?

Perry

[pietlinden]

you either open the form as read only or you implement security.

[chris.nebinger]

Okay, I'll be a little more specific:

You can set:

Forms("FormName").AllowAdditions = False

OR:

DoCmd.OpenForm "FormName",,,,acFormEdit
Chris Nebinger

pi********@hotmail.com wrote:

you either open the form as read only or you implement security.

[pietlinden]

Thanks Chris. Nice cover for me! Sorry, must be the ADHD. I like the
_really_ short answers!

[perryche]

Thanks all... that works fine, I am sure. I will try that... Also,
as I stumble around, I found the Before Insert Event and I simply put a
check there as:

If..... then
Cancel = True
End If

That works as well.

Perry