Question

[radicalrik]

Does anyone know how I would go about inputting data in a field (employee name) and get other information from another database?

Example: If I type in the employees name, I would want all the other fields associated with that employee record to be automatically enter in the other fields, like home phone, cell phone, ect. Here's the tricky part.... The employees name is located within another database from the one I'm orginally pointing to on the form.

 

[radicalrik]

When you need data from more than one table to populate a form or report, create a query that joins the tables and select whatever fields you want. Then use that query as the RecordSource for the form or report. When you type in the EmployeeID or select the employee from a combo, the related fields will populate as soon as you tab out of the EmployeeID field.

If your employee data truely is in a separate database, link to that database and choose the employee table. Then you can use the linked table as if it were local.

Is the RecordSource the same as the Control Source for the field?