Edit vs Add

[Sol]

Hi!

Is there a way to prevent users from entering in new records when a form is open in Edit Mode?

Thanks!!

 

[R. Hicks]

Change the Allow Additions property of the form to No.

HTH
RDH

 

[Sol]

i'm using the same form for add and edit mode- will this still work?

Thanks Again

 

[R. Hicks]

Yes, if you open this form from a main switchboard. Make a button to open the form in edit mode and a button to open it in data entry mode.

Leave the Allow Additions property set to No.

The code to open the form in Edit mode would be:
DoCmd.OpenForm "YourFormName", , , , acFormEdit

The code to open the forn in Data Entry would be:
DoCmd.OpenForm "YourFormName", , , , acFormAdd

("YourFormName" should be the name of your Form)

HTH
RDH

 

[Sol]

Thanks! This helped :0)