combo box search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
Click to expand...
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.
 
Back
Top