DatabaseObjects
ObjectExists(ByVal objCollection As IDatabaseObjects, ByVal vKey As Variant) As Boolean
ObjectExists returns whether the key exists within the collection. If the collection's IDatabaseObjects_Subset has been implemented then ObjectExists will only search the subset not the entire table.
'Print whether the product with code 'PC12345' exists
Print "Product code 'PC12345' exists: " & DBO.ObjectExists(objProductsInstance, "PC12345")