How to pass parameters from Form to Reports?

[epfmy]

Hi

I want to ask...

A report is using a query as record source.
That query has parameters [StartDate] and [EndDate].
A command button in a form open that report.
That form contains 2 textbox for date.

How can I pass this 2 textbox as the parameters of the query?

Query:
SELECT * FROM Orders WHERE Orders.[Date/Time] Between [StartDate] And [EndDate]

I am still learning MS Access, so please tell me if there is another way...

[MMcCarthy]

Change report query to ...

 SELECT * FROM Orders;

Command button to open the report

Private Sub cmdBtnName_Click()
Dim stDocName As String
Dim stLinkCriteria As String
 
  stDocName = "ReportName"
  stLinkCriteria = "[Date/Time] Between " & Me.StartDate & " And " & Me.EndDate
  DoCmd.OpenReport stDocName, , , stLinkCriteria
 
End Sub
 

[nico5038]

Just adding to the above comment that you need to construct a form with two textboxes, named Startdate and EndDate (See the Name property under the Other tab of the properties for those fields) and a button to trigger the code.

Nic;o)

[NeoPa]

You should replace the stLinkCriteria line of Mary's code with :

  stLinkCriteria = "[Date/Time] Between " & _
                   Format(Me!StartDate,"\#m/d/yyyy\#") & _
                   " And " & _
                   Format(Me!EndDate,"\#m/d/yyyy\#")