Stuck On Accessing Subform Control After 2 Days... Help?

Hi:

Have a employee timesheet application.

I have a form based on tblEmployees table, key Employeeid
Subform1 on that form based on tblWeekStartDate table, key weekstartdate and employeeid. I created 100 entries in this table for each employee so they can pick a week from combo box to enter their hours.
Subform2 within above subform1 based on tblTimeCard with key autonumber field.

When I click a button on main form I want to print preview a report of the form using EmployeeID from main form for critieria for main report and startweekdate field as critieria for subreport.

I'm unable to access the field weekstartdate from subform1 for the criteriea of the subreport query. Weekstardate is in the header of subform1.

In subreport query I'm using for weekstartdate criteria:
Forms!mainform!subform1.form!weekstartdate and query ignores it.

I also created an unbound textbox on mainform with:
=Forms!mainform!subform1.form!weekstartdate
thinking if I could get the subform1 value onto main form then the criteria in subreport query would access it but get #Name.

I did create a dialog box form where when clicking the print button on main form they can pick weekstartdate from dialog form and works fine. It does not make sense for the manager to pick a weekstartdate on the main form and then have to pick it again on dialog box.

I've attached the database. When the main form opens click on the report button.

Thanks!
Steve