M ~marie~ Registered User. Local time Today, 12:57 Joined Jan 23, 2006 Messages 11 Mar 6, 2006 #1 I have a data entry form and some records in it. What will I do so the entry form and records will not be edited when viewed? Last edited: Mar 7, 2006
I have a data entry form and some records in it. What will I do so the entry form and records will not be edited when viewed?
ansentry Access amateur Local time Tomorrow, 07:57 Joined Jun 1, 2003 Messages 995 Mar 6, 2006 #2 Put this in the on Open event of your form; Code: If Me.NewRecord = True Then Me.Form.AllowEdits = True Else Me.Form.AllowEdits = False End If
Put this in the on Open event of your form; Code: If Me.NewRecord = True Then Me.Form.AllowEdits = True Else Me.Form.AllowEdits = False End If
M ~marie~ Registered User. Local time Today, 12:57 Joined Jan 23, 2006 Messages 11 Mar 6, 2006 #3 thanks john, i'll try