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
 
Ad

Advertisements

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

Advertisements

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]

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

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

dependent combo boxes 1
Auto Fill 0
Combo Box 1
Combo box problem 7
Duplicate data on combo box 7
Unbound Combo Box 5
Combo box help 1
Combo Box, Unbound Text Boxes 2

Top