Conditional formatting / Disabled fields not resetting after Creating a New Record

[smk081]

I have a form that I've programmed some conditional formatting into both in Access and in VBA. What I am experiencing is that everything is working fine, fields that are supposed to be disabled based on the respondents answers are disabling correctly BUT when I create a new record, the fields in this case checkboxes that were grayed out/disabled previously stay that way for the new record. I didn't see a way to do conditional formatting in Access on checkboxes so everything is in VBA.

To be more particular.

I have 5 check boxes.

Option 1
Option 2


Option 3
None
Unknown

If ANY Option 1 THROUGH Option 3 is checked, it disables None and Unknown from being selected. Inversely if None is selected - it disables/grays out Unknown and Option 1 THROUGH Option 3. if Unknown is selected - disable/gray out None and Option 1 THROUGH Option 3.

So this is working just fine but when I click the button to create a new record, and say I had previously checked "None" whcih disabled Option 1 THROUGH Option 3 and Unknown - those fields are disabled on the form for the new record, the checkbox are all unchecked but the fields are disabled.

I imagine I need to "reset" these fields when the Create New Record is clicked but I'm not sure.

Any help would be awesome!

Thanks!

[pbaldy]

I suspect you need the same code in the current event, which fires when you change records. I'd have a function and call it from multiple places.

[smk081]

You mean like writing a procedure to run when the Create New Record button is pushed to "reset" the fields?

[pbaldy]

Well, you haven't shown the code but as I mentioned it probably needs to run in the current event (of the form). That will fire when the user changes records, including a new one.

[smk081]

Well, you haven't shown the code but as I mentioned it probably needs to run in the current event (of the form). That will fire when the user changes records, including a new one.

I just looked up the event "On Current" which seems to make complete sense. I'm very new to Access and VBA and didn't even realize the Form level Events that you've directed me to. Its extremely helpful.

My only concern is if someone navigates to a previous record, would it override the input in that record - or would this just have to be something that would be taken into consideration when the procedure in On Current is written? E.g. if I out a procedure in On Current to "refresh" the checkboxes in my original issue, if the user returns to a previous record, the checkboxes that were previously answered, would become reset?

[pbaldy]

Still haven't seen the code, but I expected it would set controls based on others. If something different needs to happen only on a new record, use the current event and test for it:

If Me.NewRecord Then