Trouble with update query (1 Viewer)

[Mark_]

ridders,

Alternately, you could do it as a select case structure to include NULL values.

Select Case 
Case 0
     Add the record
Case Null
   MsgBox "Programmer needs to check the criteria because they messed up!" & chr(13) & chr(10) &_
 "See: https://support.office.com/en-us/article/dcount-function-counts-the-unique-values-in-a-record-set-227efeeb-5bb3-4343-8277-a0750daf3496"
Else
    MsgBox "Record exists"
End Select