Lock Records

[JOE POLLOCK]

I have a formand a subform in our database which allow sales orders to be
entered. One issue I am having is when the form is opened to enter a new
order. Inevitably the previous record is overwritten. What do I need to
change so that this is avoided. No matter how much training one is given the
error will still happen.

 

[John W. Vinson]

I have a formand a subform in our database which allow sales orders to be
entered. One issue I am having is when the form is opened to enter a new
order. Inevitably the previous record is overwritten. What do I need to
change so that this is avoided. No matter how much training one is given the
error will still happen.

If you want the form to ONLY be used for entering new records - never editing
or viewing existing ones - you can set the form's Data Entry property to yes.
You could have a separate form for editing, or even another form with its
Allow Edits property set to No just for viewing.

An alternative is to jump to the new blank record on opening the form: in its
Load event put

Private Sub Form_Load()
DoCmd.GoToRecord acForm, Me.Name, acNewRecord
End Sub