Combo box help!

  • Thread starter Thread starter Dobbs734
  • Start date Start date
D

Dobbs734

Hi, this is my first time using this but i think this may be a pretty easy
question...

I have a table that has a vendor name, address, city, state, etc. I want to
make a form where a user will select the vendor by means of a combo box, then
the rest of the fields (address, city, state, etc.) will populate.
I tried to make this form already, but everytime I went to choose a vendor,
the data for the address, city, state and the rest never fill in. Those
fields stay the same and don't change to the vendor I selected. However, when
I click the "next record" button on the bottom of the form, the vendor,
address, city, state and everything else changes accordingly.
Am I missing something here? or is this a real easy solution?
Thanks!

-Mike
 
Yes, I want the the fields proceeding the combo box to fill in the data from
the table/query. What is the cbo wizard? I usually make all of my forms from
design.

Thanks again.

-Mike
 
I got the wizard to make the combobox and show the values in the combobox I
wanted...but, I still need the rest of the fields below to read that value
and fill in.
 
I did not find a "Find a record..." option when I made a new combobox. The
only options i have listed are "I want the combobox to look up values in a
table or query" and "I will type in the values that I want"
The fields that I want populated is bound to my table.
--
-Mike


ruralguy via AccessMonster.com said:
Is your form and the controls on it bound to the query? Did you pick option
#3 "Find a record..."?
I got the wizard to make the combobox and show the values in the combobox I
wanted...but, I still need the rest of the fields below to read that value
and fill in.
Are you saying you want your ComboBox to find a record in the underlying
query/table? If so, the cbo wizard knows how to do that. Just create a new
[quoted text clipped - 15 lines]

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
 
Back
Top