Using Tag Property of combobox controls

[User777]

Hello all...need some direction on an issue regarding the tap property of several combobox controls...
I have a form that has 10 combobox controls with the same tag property..the values for the combobox are only YES/NO...
What i want the form to do is to look at the values of the comboboxes with the same tag and tell me if any of them have a "NO", and if so to populate an unboud textbox with "NO"...or if they are all "YES", the populate the textbox "YES"...
Can this be done using the tag property?...Please advise...thank you!

[June7]

I suppose could be done, I've never used tag property.

But why not just code in each checkbox Change event procedure:

Me!fieldname = Me.checkboxname

[TG_W]

I'm with June on this one. I tried tinkering around in VBA calling the tag, but I kept getting compile errors. That code, per your requirements, would be an If...Then with 10 ANDs in there (Me.cbo1 = "yes" AND Me.cbo2 = "yes"...). I assume you may have known that already thus trying to use a common Tag property.

[User777]

I'm with June on this one. I tried tinkering around in VBA calling the tag, but I kept getting compile errors. That code, per your requirements, would be an If...Then with 10 ANDs in there (Me.cbo1 = "yes" AND Me.cbo2 = "yes"...). I assume you may have known that already thus trying to use a common Tag property.

Hi all
THank you for your replies...what i ended up doing is adding a formula to the unboud textbox to look for values of each combobox....i added the formula below in the control source of the textbox...see below:

=IIf([AuditType]="RPP" And [Sec1_01]="YES" And [Sec1_02]="YES" And [Sec1_03]="YES" And [Sec1_04]="YES" And [Sec1_05]="YES" And [Sec1_07]="YES" And [Sec1_08]="YES" And [Sec1_09]="YES" And [Sec1_10]="YES" And [Sec1_11]="YES" And [Sec1_12]="YES","YES","NO")))

so basically, if any of the comboboxes (Sec1_n) have a no, the the textbox value will show "NO"....they all have to have "YES" for the value in the textbox to show "YES"...
Thanks again for eveyone's insight.

[June7]

Sorry, I did not ready OP thoroughly enough and did not realize the true requirement. That does make for a long expression. I suppose you will have to replicate it in queries/reports.