A form (Form1) has a subform (subform1), and this Form1 has combo to filter the records of subform1.
it works perfectly fine with the following example syntax.
I have problem when this Form1 is linked to Navigation tab of Dashboard form
How can I modify syntax to make this combo workable, where this Form1 has become a subform on dashboard.
thank you.
it works perfectly fine with the following example syntax.
Code:
[Forms]![Form1]![SubForm1].Form.Filter = "Status= '" & Me.cboStatus & "'"
[Forms]![Form1]![SubForm1].Form.FilterOn = True
I have problem when this Form1 is linked to Navigation tab of Dashboard form
How can I modify syntax to make this combo workable, where this Form1 has become a subform on dashboard.
thank you.