I'm trying to build a form that will track information for utility payments for a college campus.
On the form I have the fields for account 1 and percentage 1 visible and accounts 2 and 3 and percentages 2 and 3 are not visible. I want to makes account 2 visible if percentage 1 is less than 100% and account and percentage 3 visible if 1 + 2 is less than 100%.
this is the code I have and it isn't working:
Private Sub NCSANum1Percent__Exit(Cancel As Integer)
If NCSANum1Percent < 100 Then
NCSANum2.Visible = True
NCSANum2Percent.Visible = True
Private Sub NCSANum2Percent_Exit(Cancel As Integer)
If (NCSANum1Percent + NCSANum2Percent) <> 1 Then
NCSANum3.Visible = True
NCSANum3Percent.Visible = True
NCSANum2.Visible = False And NCSANum2Percent.Visible = False