Disable Text Box Based on Value of Another Text Box

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.
 
S

SPK

Hi Al Campana/SherryN

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disabled Text Boxes Based on Value of Another Text Box 4
Disabling/enabling a text box in the form 2
Change the font color/background of a text box depending on value 6
Enable disable a text field based on date field 1
Hide text box 1
Filtering based on a Text Box, 2
Text box visible on a continuous form 3
Choose a value from a combo box based on a text box 0

Top