disable text box based on criteria

[DCV0204]

Hello, My form has 3 tabs the tab with multiple bound fields is Inital_Review (screen shot below). I would like the address fields on this tab to be disabled if any of the ProgEligEndReason (6) fields = the following: "Option1", "Option2", "Option3" Otherwise I would like the address fields to remain enabled. Here is what I have to begin, but when I select an item from the combo box it does not update the form automatically after I exit or make a selection to the field. I have tried repaint, refresh or requery after Me.Address.Enabled = False.
I hope you can get me started as I have a deadline soon to get this completed. Any help will be greatly appreciated.

printscreen.zip
Private Sub Form_Current()
If Me.ProgEligEndReason = "Lic. Suspend/Revoked" Then


Me.Address.Enabled = False
Else
Me.Address.Enabled = True
End If
End Sub

[Missinglinq]

...but when I select an item from the combo box it does not update the form automatically after I exit or make a selection to the field...

Your code needs to be in the ProgEligEndReason_AfterUpdate event as well as in the Form_Current event.

Linq ;0)>

[NTC]

one reason it might not be working is if the combo box for Me.ProgEligEndReason is actually bound to a key value of the underlying table so that although it displays "Lic. Suspend/Revoked" the true value of the combo box might be 2 (just an example)

[DCV0204]

Ok, that worked for the single field; can you help with applying this to all 6 of the ProgEligEndReason fields with multiple options? Such as
If ProgEligEndReason or ProgEligEndReason_0 or ProgEligEndReason_1 = "Lic. Suspend/Revoked" Or "Term. by CMS" Or "Suspended by TennCare" Or "Deceased"

can this be done?
Thanks.

[John_G]

Hi -

Well, yes, it can be done, but it's going to make for a long IF statements. You have 6 fields, each of which can have 4 values, for a total of 24.

Your IF statement would be:

If field1 = value1 or field1 = value2 or .... field6 = value3 or field6 = value4 then

24 comparisons in all.

BUT, if you have the time and resources, you database structure should be re-examined. It is not properly normalized, in that you have 3 groups of the same data (Medicaid) repeated within one main record, which is a normalization no-no. What you have is a one-to-many relationship, which always requires two tables (at least).

This will cause "difficulties" if the business rules change, or there is an exception, where there can be more than three MedicAid groupings.

HTH

John