Originally Posted by
fadone
My application uses MS Access 2000 .I have some reports based on underlying queries...i just want to display two input parameters DATE A and DATE B on my report.The scenario is as follows;
At the query design grid,field name
ATE OF PURCHASE has an expression "Between[Start Date] And [End Date]"....How can I display on the report header, both parameters [Start Date] And [End Date] after they have been entered ?????
One simple way: use unbound TextBoxes in the report header for those dates, and then use the Report's Open event sub to grab them from the form:
Code:
Me!DateA = Forms("MyForm").Controls("DateA").Value
Me!DateB = Forms("MyForm").Controls("DateB").Value