Bound columns in Forms and resetting values

[Daryl2106]

Hi Everyone,

I have a form for student attendance that is bound to a query and stores a temporary value for ClassesAttended in a StudentEnrollment table as faculty enters the attendance. They then run an append query to write the temporary records to a StudentAttendance table. Because the ClassesAttended field is bound, when the form is opened, it recalls the last number entered for that student in that class as entered by the faculty the last time attendance was updated. I tried leaving the field unbound, but the first value enter into the first record of the form is updated automatically to all subsequent records.

Is there a way to change the properities, use code, etc. to assigne a null or 0 to the ClassesAttended field when the form opens, without the first updated record to propagate through the reaming records?

Thanks amd take care,

Daryl

[orange]

You could look at the NZ() function
http://www.techonthenet.com/access/f...dvanced/nz.php

but I think you should look at this data model
http://www.databaseanswers.org/data_...ters/index.htm

specifically the ROSTER table

[Daryl2106]

Thanks for the reply and links. The table structure from "databaseanswers" is similiar to mine. I will try the NZ() function.

Take care,

Daryl

[Daryl2106]

Hi,

Thanks for the reply. I was able to update the field to a null value.

Take care,

Daryl