Report Input not working

[pepegot]

When I type in the Input Box it gives me an error: Expected List separator.
What are they talking about? The Input Boxes below are per spec.
What tick mark do I need to enter and where-I haven't a clue.


Private Sub Report_Open(Cancel As Integer)
Dim StartDate As Date
Dim EndDate As Date

StartDate = Input("Enter StartDate")
EndDate = Input("Enter EndDate")

DoCmd.OpenReport ACCInputTest, acViewPreview, , [Initial Date]![Between StartDate And EndDate]

End Sub

 

[Smart]

I would suggest a report menu form with a startdate and end date fields

then create a query to select the required data
In the query's criteria section of your date field type

between forms![yourdateform]![startdatefield] and forms![yourdateform]![enddatefield]

create your report data source is your query

place a button on your report menu form that calls your report

roberts your mothers brother