Pass parameters from a form to a pass through query Version

[Tino11]

Hi,

I have a form that allows users to enter date parameters (Start date and end date) I am looking to pass the values keyed in the two text boxes to a pass through query.

Currently I have to edit the query and manually change the parameters:

Exec usp_KPI_New_Inc entive_WithOT '20080501','200 80531'

Can I link this to the form?

Thanks in advance.

Dave

[puppydogbuddy]

Place your query in design view, then put the following reference to your form and textboxes in the criteria row of your date column :

Between Forms!YourForm![txtStartDate] And Forms!YourForm![txtEndDate]

Replace object names I used for illustrative purposes, with their actual names.