Continuous Form data entry problems

[Boz]

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

 

[luan]

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

Hi, Linda !
I guess LastName and FirstName control in your form are unbound
control, Right ?
If so, this is the trouble come from.
HTH
Luan

 

[Boz]

Hi, Linda !
I guess LastName and FirstName control in your form are unbound
control, Right ?
If so, this is the trouble come from.
HTH
Luan

Yes they are, they question is, how do I fix it?

 

[luan]

Yes they are, they question is, how do I fix it?- Hide quoted text -

- Show quoted text -

Hi !
I think u want to show LastName and FirstName beside ClockNumber for
decription.
if so then try this recommend:
In Rowsource of ClockNumber use SQL: "Select
tbl_Associates.ClockNumber, [Last Name] & " ," & [First Name] As NAME
From tbl_Associates Group by tbl_Associates.ClockNumber;"

Properties of ClockNumber combo:
Bound column: 1
Column Width: 0";2"

HTH
Luan