Combo box help!

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
 
R

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.
 
D

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
 
D

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.
 
R

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]
 
D

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


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]
 
R

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top