Update query to remove data

[Steve in S.F.]

I have a form with a subform that’s used for entering employee test scores.
The subform has a record for each employee and there is a check box field to
indicate that employee had the test and a field to enter the numerical test
score. After the data is entered and a button is clicked, records are
appended to the employee table with the test score, date and other data and
the form is closed.

I then want to run an update query so that when the form is opened again,
any checkboxes are unchecked and the any scores are removed. I am able to
remove the checkbox by putting "False" in the "update to" line of the query
for the checkbox field. But I don’t know how to remove the score; if I put in
"Null" in the "update to" line, when you open the form again there is a "0"
(zero) in the score field. How can I make the score field be blank?

Thanks,

Steve

 

[KARL DEWEY]

Check the default value of the field in the table.
Check form's query and form to see if has Nz function along the data trail.

 

[Steve in S.F.]

Nz function?? Not familiar with that.

Check the default value of the field in the table.
Check form's query and form to see if has Nz function along the data trail.

 

[Steve in S.F.]

Oops. My mistake; I had the fields reversed in the update query. Null works
fine now to blank out the test score field. Please ignore this post.