Multiple Control Sources for One Check Box

[crhodus]

I have a check box on one of my forms call INDIVIDUAL. This field is in two other tables. Can this check box be referenced, so that if the user checks or unchecks the box, the value will be passed and saved to all three field in each table? Hope this makes sense.

Tanks

 

[jstutz]

I guess my first question is why do you have the same checkbox in three tables? I should think you wouldn't need that. It's very possible that I'm not thinking out-of-the-box enough, and perhaps there's a really legit reason for needing this. It just seems to me that this breaks table normalization rules.

Regardless, you could create a query that included the Individual check boxes from all three tables. On your form, put all three check boxes. Hide two of them. Then in the AfterUpdate event for the non-hidden checkbox, set the value of the two hidden checkboxes to the value of the non-hidden box like:

me.chkNonHidden1 = chkVisible
me.chkNonHidden2 = chkVisible

That's one way to do it... I could probably come up with some more if this doesn't solve your problem.

js

 

[crhodus]

The check box(s) is used to select a records from my company table. When this field is set to true, the data for this particular company, along with the rest of the companiesthat were selected, is exported to an excel sheet. After the data is exported, the field is set back to false. I wanted to use this same feature to export data from other tables that relate to these companies.

I've finally decided it would be best to trash this idea and allow the user to decide what is to be exported. So now I have 3 different boxes that allow the user to decide which tables to export.

Thanks for your suggestions though.