Coding for an After Update Event - if field contains string "limited"then

[miatadiablo]

I know this must be more simple than I'm making it out to be. I have
a CorpName text field. Once I update that field, if it contains
"limited" anywhere in the field, I need to disable another field.
Luckily, all of the other If/Then statements I'm using for the field
are easily handled using If Right (Me.CorpName, 4) = "guar" but
unfortunately "limited" may fall anywhere within the field.

Thank you in advance for your assistance.

 

[fredg]

I know this must be more simple than I'm making it out to be. I have
a CorpName text field. Once I update that field, if it contains
"limited" anywhere in the field, I need to disable another field.
Luckily, all of the other If/Then statements I'm using for the field
are easily handled using If Right (Me.CorpName, 4) = "guar" but
unfortunately "limited" may fall anywhere within the field.

Thank you in advance for your assistance.

If InStr([CorpName],"limited")>0 Then

-
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

 

[miatadiablo]

I know this must be more simple than I'm making it out to be.  I have
a CorpName text field.  Once I update that field, if it contains
"limited" anywhere in the field, I need to disable another field.
Luckily, all of the other If/Then statements I'm using for the field
are easily handled using If Right (Me.CorpName, 4) = "guar" but
unfortunately "limited" may fall anywhere within the field.

Thank you in advance for your assistance.

If InStr([CorpName],"limited")>0 Then

-
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

I knew it was easier than I was making it. Many, many thanks!