combo box search

I need assistance with combo boxes please. I have created
a combo box called "telephone number" on a form. This
control (control source) is bound to a table's
field "telephone number". The drop down list of this
combo box control displays , company name , first name
and surname, fields of the table.

How can I use the telephone number typed in my combo box
to search the table for company name , first name and
surname, select the desired row of information on the
combo box drop down list and update the other controls on
the form, if the phone number is found.

Thanks for your help.
Clive

Perhaps you can use the combo box and its columns to do what you wish. See
The ACCESS Web for some ways to do this:
http://www.mvps.org/access/forms/frm0058.htm

--

Ken Snell
MS ACCESS MVP

wrote in message
...
I need assistance with combo boxes please. I have created
a combo box called "telephone number" on a form. This
control (control source) is bound to a table's
field "telephone number". The drop down list of this
combo box control displays , company name , first name
and surname, fields of the table.

How can I use the telephone number typed in my combo box
to search the table for company name , first name and
surname, select the desired row of information on the
combo box drop down list and update the other controls on
the form, if the phone number is found.

Thanks for your help.
Clive

How can I use the telephone number typed in my combo box
to search the table for company name , first name and
surname, select the desired row of information on the
combo box drop down list and update the other controls on
the form, if the phone number is found.

Create a select query that joins the tables and fields you are interested
in, returning a single record after telephone number is selected. Then
update any fields in the underlying tables represented by your query result.