Disable Text Box Based on Value of Another Text Box

  • Thread starter Thread starter Sherry N.
  • Start date Start date
S

Sherry N.

Hello,
I need to disable two of my text boxes based on the value of another.
I want to use something like this in the After Update Property for my text
box named Branch Code but am sure I am not using the correct
syntax.

If Me.Branch_Code = "SFCO" Or "SFPA" Then
Me.RR_Rerun_Received.Enabled = False
Me.CR_Rerun_Received.Enabled = False
Else
Me.RR_Rerun_Received.Enabled = True
Me.CR_Rerun_Received.Enabled = True

End If

Great thanks.
Sherry N.
 
Hi Al Campana/SherryN

But when you scroll between records it is appearing disabled for all the
forms/records entered. can you explain
 
Back
Top