How do i make a combobox control a form

[DDWatkins]

I have a combo box which has the last the names of my clients. What I want to happen is when a user selects one of the last names I want it to update all the fields on the form that are related to that name. I am a little new and not really good at code so As much help as possible will be needed!!!!
Thanks in advance
Dywayne

 

[gcole]

You need to base the form on a query that uses the combobox.value. When you are buliding the query, right click the criteria and make it equal to the field you need. Example: Field-lastname -- criteria-[Forms]![Form1]![Combo1]

Here is the actual SQL:
SELECT [Time Billed].CustomerID
FROM [Time Billed]
WHERE ((([Time Billed].CustomerID)=[Forms]![Form1]![Combo1]));