Very new to coding so take it easy on me.
I need to know how to check a mainform checkbox from a double click on a record in a subform.
The string below sets the name of the checkbox that needs updating but I can't get the last line of code right.
Private Sub txtShift_DblClick(Cancel As Integer)
Dim deskID As String
deskID = "DeskCheck" & txtDesk <---------name of checkbox to be checked
Forms!frmMainOffers!deskID = -1 <--------trying to update the checkbox to checked
End Sub
I need to know how to check a mainform checkbox from a double click on a record in a subform.
The string below sets the name of the checkbox that needs updating but I can't get the last line of code right.
Private Sub txtShift_DblClick(Cancel As Integer)
Dim deskID As String
deskID = "DeskCheck" & txtDesk <---------name of checkbox to be checked
Forms!frmMainOffers!deskID = -1 <--------trying to update the checkbox to checked
End Sub