I have this Dlookup which i am trying to run in VBA, but i keep getting a runtime error. Where am i going wrong?
ShredCC = InputBox("Enter the Shred Confirmation Code for the process you require an Invoice for.", "ShredIT - Print Invoice")
If DLookup("ShredConfirmationCode", "tblShreddingHistory", "ShrdConfirmationCode='" & ShredCC & "' AND '" & BagOrKg & "' Is Null") Then
MsgBox "This Shredding procedure does not have a billed by method associated with it!" & Chr(10) & Chr(10) & "Before you print the invoice you must set this up.?", vbOKOnly, "ShredIT - Assign DCN"
Runtime Error 2001
You cancelled the previous operation
I am trying to show the message if the ShredConfirmationCode matches the Input box and th BagOrKg field is Null.