If i remove the "LastValidTech.Account1=[Forms]![frmDHG]![Cbo_AccountNum]" query shows the values but if i put an input and then pass value thru it then it not shows any thing. I dont know what is a problem their.

SELECT tbl_PPVResearch.TicketNum, LastValidTech.Account1, tbl_Events.txt, tbl_Events.PPVVOD_Amt, LastValidTech.Account2, LastValidTech.Account3, LastValidTech.Account4, LastValidTech.LstVldTech, tech_id.TECHCONT
FROM ((LastValidTech INNER JOIN tbl_PPVResearch ON LastValidTech.TicketNum = tbl_PPVResearch.TicketNum) INNER JOIN tbl_Events ON tbl_PPVResearch.TicketNum = tbl_Events.TicketNum) INNER JOIN tech_id ON LastValidTech.LstVldTech = tech_id.TECH
WHERE (((LastValidTech.Account1)=[Forms]![frmDHG]![Cbo_AccountNum]) AND ((Val(Left([LastValidTech].[Account1],5)))=[tech_id.corp]));

Data with input no values
[Forms]![frmDHG]![Cbo_AccountNum]
07836-047003-01


DATA WITHOUT INPUT
-----------------
TicketNum,Account1,txt,PPVVOD_Amt,Account2,Account 3,Account4,LstVldTech,TECHCONT
004275,"07836-047003-01",IJKLMNOP,$0.00,00000-00000-00,078651234514,00000-00000-00,123,Fox
004275, "07836-047003-01",ABCDEFGH,$0.00,00000-00000-00,078651234514,00000-00000-00,123,Fox

Thanks.