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

  • Thread starter Thread starter miatadiablo
  • Start date Start date
M

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.
 
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.
Click to expand...

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

-
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
 
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.
Click to expand...
Thank you in advance for your assistance.
Click to expand...

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

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

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