murray83
Games Collector
- Local time
- Today, 23:55
- Joined
- Mar 31, 2017
- Messages
- 756
so for my current foray i wish to tick a checkbox on one form called Satchel when i press a button on another form
but have hit a snag, and i belive it's an easy fix and im close but cant seem to find it to make it work
here is my current coding
have tried google and searching here and even looking here http://access.mvps.org/access/forms/frm0031.htm but to no avail :banghead::banghead:
please help
cheers
but have hit a snag, and i belive it's an easy fix and im close but cant seem to find it to make it work
here is my current coding
Code:
Private Sub cmdYes_Click()
DoCmd.SetWarnings False 'turns off the warning message about updating lines
Me.cmdNo.Visible = False 'hides no option
Me.txtNoPouch.Visible = False 'hides no option for pouch
Me.txtPouch.Visible = True 'shows keep pouch text
Me.lblGotIt.Visible = True 'shows you go it label
Me.imgOcarina.Visible = True 'shows image of item got
Me.Form.Satchel.checkOcarina.Value = True
DoCmd.RunSQL ("Update tbl_Items set [Held] = 1 WHERE [Item] = 'Jade Ocarina' ") 'adds the Ocarina to your items held
End Sub
have tried google and searching here and even looking here http://access.mvps.org/access/forms/frm0031.htm but to no avail :banghead::banghead:
please help
cheers
Last edited: