SQL statement is give me error 3061 Too few parameters. Expected 1

[bama4954]

The SQL statement works in the query grid but not in the vba. I want a search box to pop up and I will enter the EquipID into the search box then it will load the correct records into a list box for that EquipID. See below for the SQL Statement.

strSQL = "SELECT tblTag.TagNumber, tblTag.TagID, tblEquipment.Equipment, tblEquipment.EquipID " & vbCrLf & _
"FROM tblEquipment INNER JOIN tblTag ON tblEquipment.EquipID = tblTag.EquipID " & vbCrLf & _
"WHERE (((tblEquipment.EquipID) Like ['Filter Report: Type EquipID]));"

 

[bama4954]

I had forgotten to change the bound column and number of columns on cboJobID. I changed that and it worked fine.

Thank you so much. Asking you questions is making me a better and better in Access!