Allow edits (1 Viewer)

[dpw]

I'm attempting to create a button to allow users to edit records in a form when clicked in order to prevent them from accidentally changing data. I've used the code below (posted in this forum) but the records of a subform for a new record have disappeared. Where I'm I going wrong.

Thanks

If cmdEdit.Caption = "Locked Mode" Then
AllowEdits = True
cmdEdit.Caption = "Edit Mode"
Else
AllowEdits = False
cmdEdit.Caption = "Locked Mode"
End If

 

[bjackson]

i cant see that piece of code affecting your subform

at the end of your statement add
forms![formname]![subformcontrolname].requery

it may help