Enter Parameter Value

[Skip Bisconer]

I have the following query that gives me this halt. If I enter without responding to it it opens in Datasheet view as intended. It wants me to enter Query2.EmpID. This is my SQL statement.

SELECT qryPolicyByDriverName.CWSPolicy, qryPolicyByDriverName.EmpID, qryPolicyByDriverName.DriverName
FROM tblTrainingPoliciesNotCoveredDrivers INNER JOIN qryPolicyByDriverName ON tblTrainingPoliciesNotCoveredDrivers.CWSPolicy = qryPolicyByDriverName.CWSPolicy;

I don't know why this is happening. Thanks for looking at my problem.

 

[PeterF]

You probably used a sort order on EmpID in data view when you created the query, this is why you get query2.EmpID parameter question. If you sort the query now in data view and save it it should be gone.

 

[Skip Bisconer]

Thanks! That took care of the problem.