Record Yes/ no check

[PerniceJ]

Hello


I have a form with 1000 different record filter base name.



EX

Name

DESCR

Type

Pictures

Jon test Yes/no

Yes/no
Jon No test

Yes/no

Yes/no

What i am trying to do is every time record said "test" under

DESCR

it in It set the field to enable False

If Me.DESCR.Value = "

test

" Then
Me.Pictures.Enabled = True


Else

Me.Pictures.Enabled = False
End If


End Sub


The following only work when test is the record in that set.

Thanks
Jonathan

[orange]

You have a Form and on that Form you have 1000 filters?

Are you asking "How do I find 'text' anywhere in me.DESCR?" then try

If Me.DESCR Like "*test*" Then
  Me.Pictures.Enabled = True
Else
  Me.Pictures.Enabled = False
End If
End Sub

[PerniceJ]

Hello


Thanks. This code block all different types in

DESCR field

thanks

[orange]

? Solved? Still an issue? We need more info.

[PerniceJ]

Hello

The code only work when Test is the only record in that set.

Thanks

[orange]

The code only work when Test is the only record in that set.

I don't understand your post?? Do you have a solution to the "issue"?
If not, then please describe the "issue" in clear terms with an example or 2.

[PerniceJ]

Hello


My apologies


Ex 1

Work

Name Desc Pictures
Jon Test Yes/No

Jon Test Yes/No

Jon Test Yes/No


Doesn't work In this example only want test to be Test to

Enabled. All record are block.

Name Desc Pictures
Jon Test Yes/No
Jon not Yes/No

Jon Test Yes/No

Thanks

[orange]

??? DESCR or Desc ???

I need a clear example --I do not understand your requirement.

It seems a field name may have changed?

[PerniceJ]

Hello

Feild name doesnt change the the value does

Ex
Field name

DESCR

Value
Pot
dish
dog
fish
Test

Need make everting in this field false "

Pictures.Enabled = False" expect Test for that record set

Thanks

Thank

[orange]

If you are saying the Enabled is backwards, then try this

If Me.DESCR Like "*test*" Then
  Me.Pictures.Enabled = False
Else
  Me.Pictures.Enabled = True
End If
End Sub

If English is not your native language, then write your post in your language and use Google translate to get an English version for posting.