Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

String to sets the name of a checkbox

Status
Not open for further replies.

Roosters

Technical User
May 14, 2000
61
AU
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
 
Thanks dhookom but I don't understand, I used the Parent reference but Access is now trying to find the field Parent. As I said I am very green at this so sorry if I sound dumb
Phil
 
I am slow. Just worked it out, thanks for your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top