Completing fields based on data in another field

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7450-completing-fields-based-data-another-field.html
badge that is entered.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7450

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
--
Linda

Do you agree or disagree with the writer above? Why not share your immediate thoughts with us! Login Now! or Sign Up Today! to share your views... Gurfateh!

You can select multiple fields in a combo box. Set their widths like:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7450

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7450
http://www.datastrat.com
http://www.mvps.org/access


"Linda" wrote:

> 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
> --
> Linda
>