Do a SELECT OurRef FROM RecordInUse WHERE OurRef = Value_To_Look_For

Create a recordset

If the recordset is empty, it doesn't exist. If the recordset is not empty, it does.