Auto fill

[ThomP]

I have a table (and form) that list Organs that have cancer. I want fill a
text box with the word "Yes" if the Organ is Brain, or Lung.

Any ideas?

Thanks in advance.

 

[Duane Hookom]

Try
Control Source: =[Organ] IN ("Brain","Lung")
Format: Yes/No

 

[Marshall Barton]

I have a table (and form) that list Organs that have cancer. I want fill a
text box with the word "Yes" if the Organ is Brain, or Lung.

Use a text box expression like:

=IIf(Organ = "Brain" OR Organ = "Lung", "Yes", "No")