Populate Fields

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

 

[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."

 

[Linq Adams via AccessMonster.com]

If you're talking about entering a customer code and retrieving the
corresponding record, here's a quick step-by-step:

If you haven't already done so, create a form based on your table or query,
including all the fields you want displayed. Then simply:Add a combo box to
your form.

The Combobox Wizard will pop up

Select "Find a record based on the value I selected in my combobox."

From the table or query the form is based on, click on the field you're
searching by (Customer Code in this case) to move it to the right side.

Hit Next.

Size the column appropriately.

Hit Next.

Name the combobox.

Hit Finish.

Now you can drop the combobox down and scroll down to the item to search by,
or you can start to enter the item, and the combobox will "autofill" as you
type. Hit <Enter> and the record will be retrieved.