Data Access Page error: Data provider failed while executing a p Version: 2003

[Cap'n Dave via AccessMonster.com]

Greetings,

I am having a problem saving my access form as a data acess page. Although
this form works fine in Access when accessing it as a web form I get these
errors:

Data provider failed while executing a provider command - click OK/Cancel

Invalid SQL Statement; expected 'Delete', 'Insert', 'Proceedure', 'Select',
or 'Update' - click OK/Cancel

This is a simple 2-tier implementation with IIS and the Access database both
on the same server.
UseRemoteProvider = False

I have narrowed down the problem to 2 combo boxes on my form. The 2nd combo
box filters data from the table based on the 1st combo box value. If I leave
out the filtering the DAP runs fine, when I have the filtering the DAP bombs
with the above errors. Here are the select statments:

This one bombs out....

SELECT tblEmployees.EmployeeID, tblEmployees.LastName, tblEmployees.FirstName,
tblEmployees.CompanyID, tblEmployees.Title FROM tblEmployees WHERE ((
(tblEmployees.CompanyID)=Forms!frmEnrollment_ver1Web!cboCompanyID)) ORDER BY
tblEmployees.LastName, tblEmployees.FirstName;

This one works....

SELECT tblEmployees.EmployeeID, tblEmployees.LastName, tblEmployees.FirstName,
tblEmployees.CompanyID, tblEmployees.Title FROM tblEmployees ORDER BY
tblEmployees.LastName, tblEmployees.FirstName;

How do I "filter" the ListRowSource using the value from the combo box?

I really need to filter the data so the end user selects the correct employee
for their site. Any help would be greatly appreciated.

V/R

Dave Lowe
Camp Slayer, Iraq