Sub form clear with new record

[KLahvic01]

Here is an instersting question. Either it is that unique or I havent searched for the correct things, but I havent found the answer I am looking for.

I have a main form with a subform linked with CollectionID field, basically the subform is a series of checkboxes that when checked an unbound text field with numeric values becomes available and is unique to that record on the main form. What I am trying to do is when a new record in the mainform is selected then the subform goes back to original state with the check boxes blank and the text fields not visible until checked again. right now what happens is the checkboxes become unchecked but the checkboxes remain visible.

Not sure how to resolve this.

 

[KLahvic01]

I have this working, but here is the problem I encounter. When I move to a new record all is well, but when I try to go back to an existing record the values in my unbound text boxes are gone.

These are populated based on values assigned by the checkbox being checked. The checkboxes stay checked but the values in the corresponding unbound fields are gone.

I have tried a requery and a refresh function in the on current event of the subform but it doesnt work, unless I used the wrong code, I just used me.requery on the sub forms on current event.

Any ideas?