Buttong Enabling contingent on several foem field values without using IF statements

[xtcal]

Hello -

I have created a form for users to validate data. This form contains 20 text controls. 7 of these controls are designed to monitor validation status = values can be "N/A", "In Progress", "Pass All", or "Fail All". The names of these 7 controls begin with the characters "fld".

I also have a button control on this form. I am designing this form so that this button is not enabled until ALL of the 7 text controls whose names begin with "fld" do not equal "In Progress".

My question - is there an elegant way, other than using a series of IF THEN ELSE statements, of coding the form so that this button only becomes enabled if the 7 "fld"-named controls do not equal "In Progress"?

Any assistance is greately appreciated.

Thanks!

 

[Moniker]

Here you go. I'm going to guess that you're using drop-downs to limit responses to your four possible selections as this example won't handle NULLs. It's easy enough to see what I did though. If you change any of the seven textboxes to "In Progress", the button will disable itself. Change it to anything else (except a NULL), the button will enable itself.