My combo box isn't working right...

[Guest]

I am trying to set up a combo box for a data base and I can't seem to figure
out why it isn't pulling up the information. I want to be able to type in
the name of a company and it pull up all of the information like address,
phone and fax numbers, etc. I don't don't why it isn't working....

 

[John Vinson]

I am trying to set up a combo box for a data base and I can't seem to figure
out why it isn't pulling up the information. I want to be able to type in
the name of a company and it pull up all of the information like address,
phone and fax numbers, etc. I don't don't why it isn't working....

Since you don't say what you're doing, it's more than a little bit
difficult to say what you might be doing wrong!

A Combo Box by itself simply lets you select one value (the "bound
column") from a table or query (the combo's "row source") and store
that one value (a CompanyID say) into a table field (the combo's
"control source").

You can use the Toolbox Combo Box Wizard to create a combo box with
some VBA code attached which, instead of storing the companyID in a
field, searches the Form's recordsource and displays the record
matching the selected company. Did you use the wizard, and choose the
option "use this combo box to find a record"?

John W. Vinson[MVP]