All that should go in the form's recordsource is the PrimaryKey of the
Employee's table.  If you join the two tables in a query on the Employee
Number then as soon as you supply that number the other fields will fill in.

Hi John,

Since the other information you desire is stored in the Employees table,
you can simply echo it on your form using textboxes.

for instance:

Name --> EmpID

RowSource -->
SELECT EmpID
, Firstname & " " & Lastname as EmpName
, [Pay Rate]
, [Employee Number]
FROM Employees
ORDER BY Firstname, Lastname

columnCount --> 4
Columnwidths --> 0;1.5";1";1"
ListWidth --> 3.7" (sum of column widths + 0.2" for scrollbar)

then, in another textbox control -->
Name --> PayRate
ControlSource --> =EmpID.Column(2)

column indexes start with 0, so index 2 is really column 3

~~~

do not use NAME as a fieldname, it is a reserved word

Problem names and reserved words in Access, by Allen Browne
http://www.allenbrowne.com/AppIssueBadWord.html

anyway, you should store first name and last name in separate fields

~~~

for better understanding of the basics of Access, read this:
Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

Warm Regards,
Crystal

 *
   (: have an awesome day :)
 *