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