Counting records in Access that have a specific id number related to

[christophercubitt]

I have a form that users utilize to write a referral. A referral connects a client with a company. I am trying to get a box that counts the number of referrals a specific client has had. The goal is to create a box that displays the number of previous referrals a client has had on the form.

 

[LeonAtRC]

You need a tble of clients with an integer field that is incremented each time a client gets a referral.
When the form opens populate the box with the current number from the cient table.
then update the fild and the box every time a new referral is created.

 

[PWise]

LeonAtRC:
this will create a non nomelised database

christophercubitt:

Do you have a table where you store referral information
if yes create a textbox that the control source is

=dcount("*","referraltable","client=" & me.client)

change fields names to your fields names

if no you better create a referraltable and do as above

 

[christophercubitt]

I have a table that logs all the referrals. I tried entering the text box with the suggested control source but wound up with "#Name?" in the text box. I would use "ClientID" to count the number of referrals, and the referrals are recorded on a table called "Referrals".