Allow Edit - No Addition with VBA

[EllieFant]

I have a form that I use to allow users to search for a first name of an employee and open the form to all records containing that name. I want to open the form and allow edits but not allow deletions or additions. I know that I can set this in the forms properities, but there are times that I will want the form to allow deletions and additions. This is the code I am using behind my search button on my search form:

DoCmd.OpenForm "frmEmpJob", acNormal, "SearchFirst", "", acEdit, acNormal


What do I have to change?

Thanks for the help!
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net

 

[EllieFant]

got the help I needed - thanks anyway Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net