[AccessD] Concat Again

[Bob Heygood]

Hello to the list.

Brain lock here. Just can't make this work:

     Set rstEquip = dbs.OpenRecordset("SELECT * FROM tblEquipment WHERE EquipID =" & " & Me.txtEquipID & ")


 DAO A 2010  
Very sure this is obvious. But not to me right now.

TIA

Bob