Hello,

I am creating a form that displays invoice entries that contractors submit for payment. At the top of my Access form I have a control that should display a duplicates warning if the record has a duplicate order number [OrderNo] or project id [ProjectID] that is already in the tblInvoiceSubmi ssions. The contractors can only be paid once per order/project.

I am currently using an expression with the DCount function...