Loop Through Records, Check Values of Check Boxes and Implement Code (1 Viewer)

DaLoaf said:

Thanks for all the responses.

Yeah I'm self taught on VBA so sometimes I miss the easier solutions. MajP, what, you don't like my Rube Goldberg machine of coding? ;-)

Although I've been hesitant to use Dsum and Dlookup (for performance reasons), those do seem to be a much easier solution.

As far as the structure being an issue, it's not, but perhaps it would be easier to understand if I told you all that controls A-E are US States (which I renamed for this post).

So basically all I'm looking for is that if I check a state, let's say New York, in any sub-record, I just want the main record to reflect NY as well. And if NY is unchecked in any subrecord, as long as it's not checked in another subrecord, it would uncheck on the main form.

I think the Dsum/Dlookup route is going to be the best approach for this and I appreciate everyone's help.

Click to expand...