Edit/Data Entry

[EmmaW]

I have set the properties on a form to 'yes' on the data entry option, but I want to be able to edit other records in the same form.

 

[R. Hicks]

There a several ways to do this. You could do it using the Data Mode argument of the docmd.OpenForm method. Another simple way would be to add a cmdButton on the form you have set to Data Entry property to Yes. Name this Button cmdViewAll then use the code below with the On Click event of the button.

Private Sub cmdViewAll_Click()
Me.DataEntry = False
End Sub

HTH
RDH

[This message has been edited by R. Hicks (edited 07-10-2000).]