Populate Fields

D

dbelle

I'm having the hardest time trying to remember how to populate fields in a
form. I have a form whereas I enter all data. I want to populate the field
when I enter in a customer code. I am not sure when and how to create a
combo box.

Could someone please explain. I am familar with Access but please give me
step by step directions.
 
A

Al Campagna

dbelle,
Asking how to create, setup, and utilize a Combo box does not lend
itself well to email solutions in a newsgroup. It is just too "broad" a
question for meaningful email responses.

You should have some Access reference book/s on hand that can teach
you how to create a combobox, how to set it up, and how to populate it
with the values you need.
Or, perhaps a beginner's course in Access at a local community college
or tech school, if available, might be very useful.
If your form design Toolbox contains the Control Wizards icon...
set it to ON... and whenever you add a combobox to your form, the combobox
Wizard will guide you, step by step, through the process. It's not perfect,
but it should help...
The web can also assist you. Try searching on
"microsoft access" "how to create" "combo box"
I found some good beginner's videos on combos on YouTube...
http://tinyurl.com/mbk4zw

Once you learn the basics of creating and populating combo boxes,
then... we would be able to help you to select a CustomerID from that combo
and display all the ancillary information such as Address, City, Zip,
PhoneNo... etc.. etc... on your form.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 

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