Combo box help!

[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

 

[ruralguy via AccessMonster.com]

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
cbo and pick option #3.

 

[Dobbs734]

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

 

[Dobbs734]

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.

 

[ruralguy via AccessMonster.com]

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]

 

[Dobbs734]

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

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]

-Mike

 

[ruralguy via AccessMonster.com]

That means your form does *not* have a RecordSource and in not bound. Why not
bind the form to your query?

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.

Is your form and the controls on it bound to the query? Did you pick option
#3 "Find a record..."?

[quoted text clipped - 7 lines]