New Record, Clear Checkbox on form

[Certified]

I have a form with the following items:

• - Comments (Textbox)
• - Additional Info (Textbox)
• - Updated Comments (Textbox)
• - Checkbox

The first two textboxes control source a query. The last textbox (Updated comments) is calculated.

The calculation is as follows:

If checkbox is true then updated comments = Comments + additional info. If not, updated comments is = comments.

Here is my issue:

If I check the box for the first record, all of the following records checkbox is also checked (True). How can I make the checkbox default value false when I got to a new record?

thanks!

 

[Joe4]

Since the CheckBox is unbound, it is not attached to anything, so the value doesn't change as you move from record-to-record. So you want it to reset to "unchecked" every time it moves to another record (whether new of existing).

We can use some VBA in the On Current event of the Form to do that. If the checkbox was named Check1, here is what that code would look like:

Private Sub Form_Current()
    Me.Check1 = False
End Sub

 

[Certified]

Works perfectly! Thanks!

 

[Joe4]

You are welcome!

I am little curious though, what purpose does this serve? Since neither the checkbox nor the calculated field are bound, it only changes it on the form at that time (no changes are permanent).
Are you printing the Form or something like that?