SQL Statement, Seeking advice

[d9pierce1]

Hello All,
I have the following SQL statement and need to know how to write. I highlighted where the problem is. I need the two ID's to and two Cbo's to work together in the WHERE? I dont know how to write this. Thanks
Dave



SELECT [Tbl_Phone].[PhoneID],[Tbl_Phone].[AccountNameID],[Tbl_Phone].[PhoneTypeID],[Tbl_Phone].[PhoneNumber],[Tbl_Phone].[Ext]
FROM Tbl_Phone
WHEREAccountNameID,PhonetypeID=[CboAccountNameID],[CboPhonetypeID];

[ArviLaanemets]

...WHERE AccountNameID=[CboAccountNameID] AND PhonetypeID=[CboPhonetypeID]

[isladogs]

Try this

SELECT PhoneID, AccountNameID, PhoneTypeID, PhoneNumber, Ext
FROM Tbl_Phone 
WHERE AccountNameID=Forms!YourFormName.CboAccountNameID AND PhonetypeID= Forms!YourFormName.CboPhonetypeID;

I've removed unnecessary [], added a space after WHERE and fixed the WHERE clause syntax.

If running this from the form with those controls use the Me. syntax instead

[d9pierce1]

Thank you so much!