I have a toggle box next to a subform. When the toggle is clicked, the subform should allow deletions/additions/edits. When the toggle is clicked again, the subform should not allow such.
I've tried the caption name for the subform but that doesn't seem to be working. What's the name of a subform?
Edit: In the following sub
I've tried "[Note Information Subform]", "Forms![Note Information Subform]", "Forms![Apprentice Information]![Note Information Subform]", "[Note Info]" <- the record source
I've tried the caption name for the subform but that doesn't seem to be working. What's the name of a subform?
Edit: In the following sub
Code:
Private Sub Name_Toggle_Click()
If [Name Toggle].Value = True Then
[Name Toggle].Picture = "F:\Access\redbutton.bmp"
[Note Information Subform].NavigationButtons = False
ElseIf [Name Toggle].Value = False Then
[Name Toggle].Picture = "F:\Access\bluebutton.bmp"
[Note Information Subform].NavigationButtons = True
End If
End Sub
Last edited: