fill in fields

R

rml

I have a table with 10 fields. Five of the fields are
customer information. I would like to create a form that
had a combo box with customers names and when selected,
it would fill in the rest of the fields. Not sure what
would be the best way to go.

Thanks.
 
J

John Vinson

I have a table with 10 fields. Five of the fields are
customer information. I would like to create a form that
had a combo box with customers names and when selected,
it would fill in the rest of the fields. Not sure what
would be the best way to go.

Thanks.

The best way is to Not Do It This Way. <g>

As a relational database, Access works best if you use the
"Grandmother's Pantry Principle": "A place - ONE place! - for
everything, everything in its place". If you have a Customer table,
that should have a CustomerID as its Primary Key, and the rest of the
fields should be stored in the Customer table *only*. If you have
other tables that reference customers, just have the CustomerID in the
other table, and use a Query or a Combo to insert the CustomerID. Do
NOT store the other customer information in the second table at all.

You can *display* the information on a Form by creating combo boxes
which pull data from the combo box - set the Control Source to

=cboCustomer.Column(2)

to display the *third* (it's zero based) column from the combo's
rowsource query.
 

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

Top