Retrieving data based on ID field

[newyorkcity]

I have two fields in a form:

Client ID Client Name


I wan to be able to enter the Client ID and have the name of that client to appear automatically under the client name field.

How do I do this?

Thank you

[lee123]

there is several ways you could do this for instants an (if statement) like this:

If client id = "what ever the id is" then
   clientname = "what ever name it is"
else
   clientname= "isnull"
end if  

lee123

[lee123]

hi it's me again i did that wrong i'm sorry i have three kids im watching here it is the right way:

Private Sub ClientID_AfterUpdate()
 
if clientid = "what ever the number is" then
    clientname.value="somename"
end if
End Sub
 

lee123

[missinglinq]

Please remember to provide a meaningful Title for any threads you start! This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions. It is difficult for the experts to answer questions when there is not enough details provided to understand the problem.

Please take the time to read the Posting Guidelines, paying particular attention to Give a clear title to your question. In keeping with these guidelines, I have renamed the thread for clarity.

*****

The simplest way to do this would be with a combobox!

Add a combo box to your form. The Combobox Wizard will pop up

Select "Find a record based on the value I selected in my combobox."

From the query or table the form is based on, click on the field you're searching by (your ClientID field) to move it to the right side.

Hit Next.

Size the column appropriately.

Hit Next.

Name the combobox.

Hit Finish.

Now you can drop the combobox down and scroll down to the item to search by, or you can start to enter the ClientID, and the combobox will "autofill" as you type. Hit <Enter> and the record will be retrieved.

Welome to TheScripts!

Linq ;0)>