Clearing Checkbox on New Record

[rossi45]

Hey everyone,

is there a way to clear a check box in a form if you add a new record?

I tried:

If Me.NewRecord = True Then
Me.checkbox = False

That doesn't seem to work when I have placed a check in the checkbox on the current record, and then create a new record, the checkbox stays.

Any suggestions?

Thanks, Mike

[Bob Fitz]

How about setting it's Default Value property to False.

[rossi45]

Thanks Bob. I tried that and it still remains checked. I tried programming it into the after update event on the checkbox and before insert and after insert events on the form...

[AccessMSSQL]

Check the underlying table field. It may have a default value set to true.

[AccessMSSQL]

Couple of other things to check:
1-Is the checkbox bound to a field from the table?
2-What is the actual name of your checkbox - make sure you have the naming correct also in your code. There are two properties in Access for a control - the bound name of the field and the name of the control. Go into Properties and select the "Other" tab and check the Name property. This is how you need to refer to it in VBA code.

Hope this helps.

[Phil1]

To clear a checkbox, I'd simply change it's 'Value'....

to clear the checkbox type:

cbMyCheckBox.Value = False