Check if record exist

[khhess]

I'm lost!
How can I check with VBA if a record exist?
I have two tables, one is tbl_SO and tbl_WO, both are in relationship.
How do I check if a record in tbl_WO are in relationship with a record in tbl_SO?

[June7]

Which is parent and which is child in the relationship?

You can either use a recordset or DLookup function. If you are looking for one specific record, then with DLookup:

If Not IsNull(DLookup("ID", "tbl_SO", "ID=" & inputID)) Then
MsgBox "Record Exists"
End If.