Form question

[Daryl2106]

Hi,

I have a EnterGrade&Attendance form with a TempAttendance field for storing attendance data before writing it to an AttendanceTable using an append action query. The query is intended to write the attendance for that week with the number of classes attendended. I am trying to get the query to pull the date from a combobox on the same form. The TempAttendance field is an unbound text box. The form itself is based on a select query that selects all the classes and students that an instructor teaches.

My current problem is that when I enter attendance data for the first student, access autofills that field in all the records on the form.

Any help would be greatly appreciated.

Take care,



Daryl

[Robeen]

Can you put your append query here so we can look at it?