Search results for query: *

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".

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'm very new to Access so I apologize that my lingo is off. The macro is in the Where Condition.

I see the name of the filter that I've applied in the where condition for the macro. I'm open to using code if it will achieve my objective.

1. The referral form is open because the button that executes the macro is open. 2. The complete macro's where condition is: [ClientID]=[Forms]![Referrals]![ClientID] And [ContactID]=[Forms]![Referrals]![ContactID] 3. ClientID, and Contact ID are Long Integers 4. The field names, I believe...

I want today's date to automatically populate in the todaysdate field so that users can avoid entering todays date every time. Please help.

Yeah I'm pretty certain. The Form that users use is called "Referrals". My objective is to pull the contact information related with the contact id and the client information related with the client id number and have it placed in the "referral report". The client id and the contact id are...

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...