Completing fields based on data in another field

[Linda]

Hi All,

I have a table that includes Employee name, Employee badge, and Employee
crew code. I would like to select or type the employee badge in a form field
and have the other 2 fields completed automatically in the form, based on the
badge that is entered.

It seems I must make the fields combo-boxes and have the source listed as
the table. However, each field then returns only the first column of data in
the table and must be selected seperately.

I have looked at some Northwind samples, but I do not understand how to do
this.

If you can help, it would be greatly appreciated!

Thanks

 

[Arvin Meyer [MVP]]

You can select multiple fields in a combo box. Set their widths like:

0"; 1.5"; 2"; 0"; 0"

Which would set the widths of 5 fields, 2 of which are visible when the box
is dropped down. The column index is zero based. To display the contents of
the fourth column in a textbox, set its controlsource to:

Forms!FormName!ComboName.Column(3)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access