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