Causing a headache

[KingRudeDog]

I have a main form [mainform] with several subforms on it, two of which are on a tab.

On the second tab [page79] there is a subform [subformlist] which has like 25 checkboxes on it, any combonation of which can be picked by the user.

I need there to be at least one pick required of this subform, else the record won't show in a general query I have, since the table the subform is based on is linked to the record.

Is there anyway to make making a choice of one of at least one of these checkboxes checked a manditory thing before the user can close or move on to the next record?

I've tried making an "Other" box that on the Table has a default value of "True" which I thought would cause it to show in the query record...to no avail.

The only true way to make this work is to have it mandatory that the user pick from AT LEAST one, usually more before the record is complete.

Any help? Other than writing a MASSIVE If...Then statement...?

Or is there a way to make it so the choice isn't required for the record to show up in the query?

I'd post...but my db is too massive, even zipped.

 

[KeithG]

If the user does not check one of the boxes no record is created in the table correct? You could use VBA to check and then uncheck one of the boxes. This way the record is actually created . You could use a left join to show all records from your table too.

 

[KingRudeDog]

Your A Fricken Genius!!!! I ca't beleive I didn't come up with the vba idea myself...I bow before your superiorness...