I have a question about checking for duplicates in a continuous form.
The form’s Data source is “qrySelectInvoicesToBeSent”.
It displays a list of invoice records.
This query has a field “Client ID”
During the load event for the form I want to say:
If ANY clients have more than one invoice – display a MsgBox.
I think I will be using DCount() but can’t figure out the syntax to use in this case.
Hope someone can help.
8/22/2022 - Mon
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat