fill in fields

  • Thread starter Thread starter rml
  • Start date Start date
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.
 
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.
Click to expand...

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.
 
Back
Top