Combo box not working?

B

BaDonkaDonk

I created a table and created a form out of that. I added a combo box to the
form and clicked the box to look up a record from a table when it asked me
what I wanted to use the combo box for. I want the combo box to be able to
pull up the information I have typed in my table on my form. When I go into
forms and go to the combo box to make sure the information pulls up the only
information that pulls up is the name of the company and nothing else like
the address, phone number, etc. I have on the form. I tried selecting every
value to put in the combo box thinking that might work, but still only the
name of the company comes up. Did I check the wrong box when setting up my
combo box? Did I set up something wrong when making my table? I have used a
combo box before in access and it worked, but it doesn't seem to be working
for me now.
 
K

kabaka

Your combo box can only return values from one field in your table (i.e.
Company Name OR phone # OR address etc. - to get the whole row requires VBA).
You can display more than one field in your combo though by changing the
"column count" property. If you don't want the Company name returned change
the "bound column" property to the one that you want. My bet is that you
have it set to return column 1 - the default - which is the company name
field.
 
B

BaDonkaDonk

How do I change the bound column? I saw the bound column button in the combo
box section but tried to change the number but wasn't sure what number to
change it to...why is it that the combo box worked before for me but it won't
work now? did I change something last time I was doing this?
 
Top