Resetting Checkbox to blank in a subform

[rocco]

I have created a form that has to two subforms inbedded.

1. I enter a name in a box to search for user location, designation, etc and the 1st subform shows the result.
2. The 2nd subform shows two check boxes that are link to the master table that I am updating and if the user is found it will show if the he/she took test1 (chek box) or test 2 (check box).

This is the problem I am having.
The boxes are updating correctly if I have a user in the main table that took the test.
When type a new search I would like the boxes to default to uncheck.
I tried refreshing the subform - not working.
Set the box to default value of the box = 0 - still not working.

Not sure what other VB code to apply so that the boxes will reset to blank in the subform.

Any suggestions will surely help me as I am going ball trying to solve this problem.

 

[dhookom]

How about providing the record sources of all forms? Are the two check boxes bound to fields in a table?

Duane
Hook'D on Access
MS Access MVP