Access 2000 queries return blank when using form parameters

[mike_980]

I am currently using access 2000 and for some reason I can't seem to be able to get the queries to lookup a value in a form.



The criteria I am using is:
[Forms]![frm_PID_Select]![PID_desc]


I tried this first in a crosstab query and it wouldn't work so I then tried it in a simple select query and still no luck. The criteria works perfectly when I enter it into a prompt if I use [Enter PID description] then manually type in the value that is in my combobox on the form.

I am used to Access 2010 onwards so using such an old copy might mean I have neglected something important?

[mike_980]

Here is the SQL:

SELECT [tbl_PID].[PID_description], [tbl_test].[LgTime], [tbl_test].[ECU_value]
FROM tbl_PID INNER JOIN tbl_test ON [tbl_PID].[PID_ID]=[tbl_test].[PID_ID]
WHERE ((([tbl_PID].[PID_description])=[Forms]![frm_PID_Select]![PID_desc]));