Report Error - Filter Report in Microsoft Access


	Back to Filter Report Comments List

Upload Images Link Email

Report Error

Werner Mildt

9 months ago

Hi, I have a Cont.Form, selected a filter and printed the report.
Everything works fine.

Private Sub Report_Load()
    Me.Filter = Forms!LogForm.Filter
    Me.FilterOn = Forms!LogForm.FilterOn
    
    Me.OrderBy = Forms!LogForm.OrderBy
    Me.OrderBy = Forms!LogForm.OrderByOn
End Sub

Then I created a menu form, Imported the Cont.Form as a subform.
I now need to call the report from the SubForm.
My question is how do I set the code in the Report?
I am getting an error message, Can't find LogForm.
I tried this Me.Filter = Forms!MunuF!LogForm.Filter
Would appreciate some help.
Thanks
Werner

	Jennifer Neighbors 9 months ago
Is your form really named MunuF? Might it be MenuF? When referring to a subform, you might try Forms!MunuF!LogForm.Form.Filter

	Werner Mildt OP 9 months ago
Hi Jennifer, I have tried to use your code, However, it still comes up with an error message. Thank you for your reply. Regards Werner

	Adam Schwanz 9 months ago
Ensure that LogForm is the name of the subform control on your menu form, the name of the form inside of it doesn't matter.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Filter Report.