greensleeves149
Member
- Local time
- Today, 20:12
- Joined
- Feb 27, 2022
- Messages
- 49
Hi all,
I've got a combo box on a form and after the user selects something, I want the corresponding details on the subform, but I'm getting a reference error in the After Event Code.
I've been trying to follow this example: https://www.access-programmers.co.u...combobox-to-filter-records-in-subform.172503/ and for my database, have used:
Private Sub cboCategory_AfterUpdate()
[Forms]![frmInvestigationSample]![frmSubformTest].Form.Filter = "[Category] = '" & Me.cboCategory & "'"
[Forms]![frmInvestigationSample]![frmSubformTest].Form.FilterOn = True
End Sub
When I try selecting something from the Combo box, I get:
"Run time error 2465- Microsoft Access can't find the field 'frmSubformTest' referred to in your expression'.
I'm not sure what's wrong here.
I've put together a watered down version of my database with sample data and attached it here- if that helps.
Could you please enlighten me what I'm doing wrong?
Thank you.
I've got a combo box on a form and after the user selects something, I want the corresponding details on the subform, but I'm getting a reference error in the After Event Code.
I've been trying to follow this example: https://www.access-programmers.co.u...combobox-to-filter-records-in-subform.172503/ and for my database, have used:
Private Sub cboCategory_AfterUpdate()
[Forms]![frmInvestigationSample]![frmSubformTest].Form.Filter = "[Category] = '" & Me.cboCategory & "'"
[Forms]![frmInvestigationSample]![frmSubformTest].Form.FilterOn = True
End Sub
When I try selecting something from the Combo box, I get:
"Run time error 2465- Microsoft Access can't find the field 'frmSubformTest' referred to in your expression'.
I'm not sure what's wrong here.
I've put together a watered down version of my database with sample data and attached it here- if that helps.
Could you please enlighten me what I'm doing wrong?
Thank you.