Checking if a record exists using two fields

Question

I have two fields that are going to be scanned into my form, I have a button on the form and when its pressed I want a Dialog box saying weather the record exists. I currently have an SQL query that pulls the record from the database.

SELECT Stock, Scanned
FROM Products
WHERE ((([Stock])=Forms!Products![Stock Code]))                                                  
And ((([Scanned])=Forms!Products![Scanned Information]));

I want to be able to check if this query returns null or not. I'm not sure if this is even the best way to check if a record exits, would DLookup be a better approach for what i'm trying to achieve ?

smoore4 smoore4 · Accepted Answer · 2013-06-24T08:01:56

Something like this should work:

Set db = CurrentDb
Set qdf = db.QueryDefs("mySelectQuery")
Set rs = qdf.OpenRecordset()
if rs.EOF then
MsgBox "The record does not exist"
else
MsgBox "The record does exist"
end if

Checking if a record exists using two fields

1 Answers