In FormA, I have a start_date and end_date fields for users to select the date range. The start_date and end_date will pass to FormB.subform where the subform is a continous form to display the records after filtered by the date range. My question is: how can I pass the date range to the subform of FormB?
I have the following two lines in FormA codes. But it is not right because FormB doesn't have data source, only its subform has.
strWhere = "LatestDate >= #" & Me!FromDate & "# And LatestDate <= #" & Me!ToDate & "#"
DoCmd.OpenForm "FormB", acNormal, , strWhere
My question is: how can I pass the parameters to subform?
April 23, 2008 2:28 AM
April 25, 2008 8:22 PM