I have a Navigation Form with a subform. Here is the basic layout:
Navigation Form: [Home Page] <<<< I know I shouldn't use a space in the name, but it's only one form
Subform: [frmInsertResults]
Control: CheckSCC <<<< This is a checkbox control
Here is the code I am using in the immediate window, and as the msgbox:
Immediate Window Code:
Code:
? Forms![Home Page]!frmInsertResults.Form!CheckSCC
VBA Code:
Code:
MsgBox Forms![Home Page]!frmInsertResults.Form!CheckSCC
It returns a run-time error '2465': Microsoft Access can't find the field 'frmInsertResults' referred to in your expression.
The main form and subform are both open in form view (even tried in layout view). I've checked the spelling of the form, subform, and control to make sure they are correct. All I would like to do is to be able to find the current value of the control in the Immediate Window so I can begin writing more code.
Dumb question, and I've done this successfully a few times today already with a different form and subform. I can't get it to work for me this time.