In this case you can put two text box [txt_date1 & txt_date2] on your form, filling them with the dates you need. In your query [Criteria section] put between Forms("YourFormName")!txt_date1 & " AND " & Forms("YourFormName")!txt_date2
Unless there has been a change in the most recent version, you cannot reference parameters in a query. This is the reason for the suggestion above about putting the date fields on a form. You can reference the form fields from the query and on a report.
This limitation is also why I personally never use the switchboard wizard in Access. It is just too limiting and there is always something I’m wanting to do that the switchboard cannot accommodate.
I would do as Hammbakka suggested. You can still use the switchboard, but you need to add a parameter form to your database and when you click on the item in the Switchboard have it open this parameter form.
The unbound parameter form will need to have a text box for each criteria item. I suggest using a combo box rather than a text box to enter the client's name. Otherwise if the user spells the client's name wrong, they won't get any results.
For the combo box, create a query that pulls all your client's names and sorts them alphabetically. I don't know if you're combining the client's first and last name in one field or if you're using a field for Last Name and a field for First Name. It will make a difference in how you setup the combo box.
In the combo box on the parameter form you need to select Table/Query in the Row Source Type property and then select your query in the Row Source property.
Then there needs to be a query for the report so you can reference the controls on your parameter query.
In the report's query in the criteria line of the client's name you reference the control name on the parameter form like below.
This let's the query know to look at this control for the criteria it needs for the client name. You do the same for StartDate and EndDate.
The Control Name for each control is in the properites window in the All tab.
Don't forget to set your report's Record Source as the query you created.
Then in your report add two text boxes and in the Control Source of each text box you would enter:
If you decide to try this, let me know if anything is unclear. I hope I didn't leave anything out.