If...then question

**jpkeller55** · 09-13-2010, 03:28 PM

The following line of code is used to look at all the values of controls except the field named "Updates".

Code:

If C.Name <> "Updates" Then

What would be the proper code to look at all values except "Updates" and another one named "LastUpdated"?

Thanks much.

**pbaldy** · 09-13-2010, 03:37 PM

If C.Name <> "Updates" AND C.Name <> "LastUpdated" Then

**jpkeller55** · 09-13-2010, 03:38 PM

Thanks Paul. I was using the word OR and that was not working for me. I see AND makes total sense.

**pbaldy** · 09-13-2010, 03:45 PM

Happy to help. The required reversal of the And/Or logic when using "<>" trips up a lot of people.