I have a database where I enter in invoice details.
I am trying to get a dialog box to pop up on my form advising me if I have keyed the same invoice previously once i tab out of the invoice number field.
Because there are multiple vendors who may have the same invoice number i want to concatenate the [VendorCode] & [InvoiceNo] fields.
I am trying to get a dialog box to pop up on my form advising me if I have keyed the same invoice previously once i tab out of the invoice number field.
Because there are multiple vendors who may have the same invoice number i want to concatenate the [VendorCode] & [InvoiceNo] fields.