Form for new data entry which link to another table

[marcvanderpeet12]

Dear all,



I have created a form in which i can input new records. In the form you have to input the personnel ID and name. But I also have a table with all employees in the company with their ID numbers. So basically I could develop the the form in a way in which I enter the number in box and the name automatically pops up (like a vlookup in word).

Does any know how i can achieve this?

Dear regards, Marc

[June7]

One method is to have a multi-column combobox that has columns for the ID and name. Review: http://datapigtechnologies.com/flash...combobox3.html
Then a textbox references the combobox column that has the name.

Another method is to include the employees table in the form RecordSource - join type would be "Show all records from <table> and only those records from Employees that match". Then have textbox bound to name field from Employees table. Set it as Locked Yes, TabStop No.

[marcvanderpeet12]

Thanks, I get the first method. Thing i do not understand however, how do you get the "second value" in the text box? How do you link it?

[June7]

In textbox ControlSource:

=comboboxname.Column(1)

Combobox column index begins with 0 so if the name is in second column the index is 1.