CLEAR A CHECK BOX ON A SUB FORM

[Mary10k]

hello,
I have a form with two subforms on it referring to the same table. Basically, I have sectioned off the fields into two subforms. I have a button on one form which saves the entry and clears the text box. What I would like to do is clear the checkbox on the 2nd subform once this is button is clicked.

Any suggestions how to do this?

 

[PHV]

Something like this ?
Forms![main form]![sub form 2].Form![check box] = False

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Mary10k]

Thank you, but where do I enter the code? Which event would I use?
Thanks

 

[PHV]

Why not in your button's Click event procedure ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244