Selection of a record populates several fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have client details held in a table. So far so good.
I want to have several forms where the required client name can be picked
from a combo list, then there are several other controls on the forms
(attributes that are all held in the client table) that should be populated
automatically when the required name is selected.
How is this done, please?
Many thanks
Little Crow
 
We have client details held in a table. So far so good.
I want to have several forms where the required client name can be picked
from a combo list, then there are several other controls on the forms
(attributes that are all held in the client table) that should be populated
automatically when the required name is selected.
How is this done, please?
Many thanks
Little Crow
Click to expand...

You can *display* the other fields by including all the attributes that you
want shown in the Combo Box's RowSource; make sure that the combo's Column
Count is big enough to include all the fields.

Set the control source of textboxes on the form to

=comboboxname.Column(n)

where n is the *zero based* position of the field that you want displayed.

Note that these fields should NOT be stored redundantly in a second table.
They should exist in the Clients table, only, and should not be stored
redundantly.

John W. Vinson [MVP]
 
Back
Top