HOW DO I CREATE A POP UP FORM THAT WILL CONTROL REPORT PARAMETERS

[tweety1201]

I am trying to create a report based on a query. I have created a popup form for data input.

In the query I have specified the required criteria Between [Forms]![Calendar]![BeginningDate] AND [Forms]![Criteria]![EndingDate]. I have created a print preview button on the Form which contains the following code

Private Sub Preview_Click ( )
DoCmd.OpenReport "Report Name", acViewPreview, , "[BeginningDate] = '" & Me("BeginningDate&quot & "[Ending Date] = '" Me("EndingDate&quot & "'"

End Sub

I cannot get the code to run. What am I doing wrong?
Please help

 

[jebry]

Hi!

If EndingDate and BeginningDate are defined in the table as Date/Time then, in your code, substitute the # for the ' in your Where clause.

hth Jeff Bridgham
bridgham@purdue.edu

 

[tweety1201]

Thanks s-)