Solved Combofilter for subform on a form linked to Mainform with navigation tabs (1 Viewer)

[Ihk]

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.

[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.

 

[CJ_London]

instead of

[Forms]![Form1]![SubForm1].Form.Filter

use
Me.[SubForm1].Form.Filter

will then work wherever

 

[Ihk]

instead of

[Forms]![Form1]![SubForm1].Form.Filter

use
Me.[SubForm1].Form.Filter

will then work wherever

Perfect and worked............ thank you very much.

 

[Gasman]

Perfect and worked............ thank you very much.

You sound suprised?

 

[Ihk]

You sound suprised?

Yes because i dont have to write complete path.