Form Trouble

[Caryisms]

How do I write an expression for a text box in a form that will allow a conditional statement based on another field.

ie. If Field 1 = "Primary", then this text box = [Field 2] & " " & [Field 3]

Thanks!

 

[Jables]

Put an unbound text box on the form. In it, type,

=Iif(condition,"text if condition is true","text if condition is false&quot

The text stuff can be any combination of text and other items on the form. The text box will display whichever value is appropriate based on how your condition tests.

 

[jrbarnett]

The following VBA will do it:
If Field1 = "Primary" Then Textbox = Field2 & " " & Field3

Or set the control source to:

=Iif(Field1="Primary",Field2 & " " & Field3,"&quot

John