Pull data from other source

[dhborchardt]

I have a form that has all the information I need
including EmployeeID but not the EmployeeName. How do I
call information from other tables/forms/queries, using
the employeeID as a key? I hope this is clear.

Thanks

 

[dpav29]

In the "control source" of the Form, click the query builder button which will allow you to modify the SQL statement driving the form. You'll then be able to bring in the table that contains the employee name and drop the fields in like you would in any query. When you close the query, it'll prompt you to change the sql statement. ..say OK. Then, the new fields you brought in will be available to place on the form.

 

[essnrv]

In Form Open event

DLookup("[EmployeeName]", "[Your Table Name]", _
"[ID] = " & Forms![Your Form Name]![ID Control Name]) Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!