Noob.. Select Query not working when combo box used for criteria

[mikehorse]

Hi
I can't get my query to return any data when trying to use the combo box on a form to define the criteria on the query design. Tthe query does work when I don't have any criteria or manually type the criteria. Any suggestions welcome. Thanks...





SELECT
TblTestSet.[TestSet Name],
tblTEST.[Test Name],
tblTEST.[Test Description],
tblTestCase.TC_Planned_Run_Date,


tblTestCase.TC_Planned_Tester
FROM
tblTEST INNER JOIN (TblTestSet INNER JOIN tblTestCase ON TblTestSet.TestSet_ID = tblTestCase.TC_TestSet_ID) ON tblTEST.TEST_ID = tblTestCase.TC_Test_ID
WHERE
(((TblTestSet.[TestSet Name])=[Forms]![Form1]![Combo0]));

[Bob Fitz]

Try:

SELECT 
TblTestSet.[TestSet Name],
tblTEST.[Test Name], 
tblTEST.[Test Description],
tblTestCase.TC_Planned_Run_Date, 
tblTestCase.TC_Planned_Tester
FROM 
tblTEST INNER JOIN (TblTestSet INNER JOIN tblTestCase ON TblTestSet.TestSet_ID = tblTestCase.TC_TestSet_ID) ON tblTEST.TEST_ID = tblTestCase.TC_Test_ID
WHERE 
(((TblTestSet.[TestSet_ID])=[Forms]![Form1]![Combo0]));

[mikehorse]

Hi Bob
Thanks for the quick response... That worked.

[Bob Fitz]

I'm glad that worked for you but if you are using lookup fields in your tables see: http://access.mvps.org/access/lookupfields.htm