Show for then one policy number if applicable in a form

  • Thread starter Thread starter CAM
  • Start date Start date
C

CAM

Hello,

I have a standand form which shows one record at a time. The record is
consist of a Policy Number and Billing Type. What I want to do is somehow
in my form shows if the user looks for a particular policy number that the
form perhaps in a lable or text box or a subform shows the user that their
are X many policy numbers in the table. The table is call Audit Inventory.
I just don't know how to do it. For exampe if the use search for policy
number "xyz" the form will show that their are 3 policy with the same policy
number. Thank you in advance.
 
Check help on the DCOUNT domain aggregate function. It should do what you
want.

Larry Linson
Microsoft Access MVP
 
Back
Top