Access 2000 and ODBC issue

[shoude]

I have an Access 2000 application which uses a linked table in one of the forms. Based on the result set chosen in the combo box the form launches another form passing the combo value as the predicate to the second form query. The sql is as follows:

SELECT dbo_pr_personnel.lastname, dbo_pr_personnel.firstname, dbo_pr_personnel.nameinit, dbo_pr_personnel.empnumber, dbo_pr_personnel.xref, dbo_pr_personnel.email_address, dbo_pr_personnel.work_phone, dbo_pr_personnel.standing
FROM dbo_pr_personnel
WHERE nameinit=Forms!f_enter_ticket.Combo0;

When we ran this application on Windows NT it worked fine... no problems. We just converted to Windows XP. Now it doesn't work. The query works if you remove the predicate. Otherwise it appears the predicate causes the generic error message: ODBC Call Failed - 3146

Any thoughts?

Thanks in advance !!!