I've created an Attendance Tracking database.  There are 3 tables

tbl_Associates
    Clock Number
    Last Name
    First Name

tblAttendance
    Attendance Code
    Hours Used
    Date of Infraction

The form for entering the information uses a query:
   Clock Number (Associate Table)
    Combo Box for Last Name ***code below***
    Combo Box for First Name ***code below***
    Attendance Code (Attendance Table)
    Hours (Attendance Table)
    Date (Attendance Table)

***Code for combo box***

Private Sub Clock___AfterUpdate()
   Me.LastName = Me.Clock__.Column(1)
   Me.FirstName = Me.Clock__.Column(2)
End Sub

The form I've designed is in a continuous form format to allow the clerk to
enter all data for the previous day.  The clock # uses a lookup for the
associate clock number, then fills in the last name and first name.  
Everything works fine until I go to the next record to enter a different
associate.  Although I change the clock number, the last name and first name
changes to the new name on all records.

What simple, stupid thing am I doing wrong this time?

THanks,

Linda