I have a form that works perfectly fine on its own, but for some reason when it is embedded in my navigation form I get a strange popup. Here's a basic description of how things should function (and do on their own):
frmJudgeType contains combo box with three choices and an OK button
user makes selection in combo box, hits OK and runs qryJudgeType which produces rptJudgeType
When the form is used within the Navigation Form, however, clicking OK produces a popup that reads:
Enter Parameter Value:
Forms!frmJudgeType!cboJudgeType
(below this is a textbox and OK/Cancel buttons)
This line is set as the criteria in qryJudgeType under one of my columns - cboJudgeType points to my OK button on frmJudgeType. But like I said, this doesn't appear at all when the frmJudgeType is ran on its own outside of the Navigation form.
If I hit cancel on the Parameter Value popup, I get an error message that reads:
Run-time error '2501':
The OpenReport action was canceled.
If I hit debug, Visual Basic appears shows my code to run the OK button, which reads:
Private Sub cmdOK_Click()
DoCmd.OpenReport "rptJudgeType", acViewReport <----This line is highlighted as containing an error
DoCmd.Close acForm, "frmJudgeType"
End Sub
Any thoughts on how to fix this line so that the form works correctly within the Navigation form (assuming that really is the issue)? Also, any chance when the form *does* work correctly, the report could be embedded within the navigation form rather than opening in its own window?
Thanks so much for any assistance, I haven't used Access much at all and what I have done has been the result of extensive googling so I hope my explanation makes some sense.