i have a SQL statment that will not always return a record. What I want is this: When there is no match for sql statment Then Add
Item to database along with mor information . any help would be appreciated.
------------------
Printable View
i have a SQL statment that will not always return a record. What I want is this: When there is no match for sql statment Then Add
Item to database along with mor information . any help would be appreciated.
------------------
You've already described the function to use: after executing a recordset Seek or FindFirst, you provide code for what to do if the record is not found this way:
If Recordset.NoMatch Then
'do stuff
End If
Dave
------------------