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.
I have multiple clients, multiple companies, and I give referrals to clients for companies regrding their services. I created a "referral" form that has a button within it that opens the report "referral report" that I hope will give the 1 clients information along with the 1 company's...
Private Sub Contact_ID_Exit(Cancel As Integer)
Company_Name = DLookup("CompanyName", "Contacts", "[Contact_ID] = " & Contact_ID)
End Sub
I am getting the DLookUp to work, but its returning the first result in the table. My code is above. how do I make it more specific to access the Company...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.