Calculated field on form

[Susan]

I would like to put a field on a form to return a Yes or
No answer depending on the contents of two other fields on
a different form:

If the value of Field1 on Form1 is yes AND the value of
Field2 on Form1 is "FT", I would like the FieldA on FormA
to show "yes", otherwise show "no".

Is this possible? Or am I going about it the wrong way?
I know NOTHING about coding, so I would like to be able to
do it through the control source on the target field, if
possible.

Thanks in advance!

 

[Allen Browne]

Set this Control Source for your text box:
=IIf(([Field1] = True) AND ([Field2] = "FT"), "Yes", "No")

 

[Guest]

Would I have to refer to the original forms in the IIF
statement: =IIF([Forms]![Forms1]![Field1].....etc. ?

-----Original Message-----
Set this Control Source for your text box:
=IIf(([Field1] = True) AND ([Field2] = "FT"), "Yes", "No")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I would like to put a field on a form to return a Yes or
No answer depending on the contents of two other fields on
a different form:

If the value of Field1 on Form1 is yes AND the value of
Field2 on Form1 is "FT", I would like the FieldA on FormA
to show "yes", otherwise show "no".

Is this possible? Or am I going about it the wrong way?
I know NOTHING about coding, so I would like to be able to
do it through the control source on the target field, if
possible.

Thanks in advance!

.

 

[Allen Browne]

Yes: if they are on a different form, you will have to include the full
reference.

You may find that they do not update automatically when the other form
changes also. Pressing F9 in the field should do it, or in code you could
ussue a Recalc.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Would I have to refer to the original forms in the IIF
statement: =IIF([Forms]![Forms1]![Field1].....etc. ?

-----Original Message-----
Set this Control Source for your text box:
=IIf(([Field1] = True) AND ([Field2] = "FT"), "Yes", "No")

I would like to put a field on a form to return a Yes or
No answer depending on the contents of two other fields on
a different form:

If the value of Field1 on Form1 is yes AND the value of
Field2 on Form1 is "FT", I would like the FieldA on FormA
to show "yes", otherwise show "no".

Is this possible? Or am I going about it the wrong way?
I know NOTHING about coding, so I would like to be able to
do it through the control source on the target field, if
possible.

Thanks in advance!

 

[Susan]

Thanks for the great info!

-----Original Message-----
Yes: if they are on a different form, you will have to include the full
reference.

You may find that they do not update automatically when the other form
changes also. Pressing F9 in the field should do it, or in code you could
ussue a Recalc.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Would I have to refer to the original forms in the IIF
statement: =IIF([Forms]![Forms1]![Field1].....etc. ?

-----Original Message-----
Set this Control Source for your text box:
=IIf(([Field1] = True) AND ([Field2] = "FT"), "Yes", "No")


I would like to put a field on a form to return a Yes or
No answer depending on the contents of two other

fields
on

a different form:

If the value of Field1 on Form1 is yes AND the value of
Field2 on Form1 is "FT", I would like the FieldA on FormA
to show "yes", otherwise show "no".

Is this possible? Or am I going about it the wrong way?
I know NOTHING about coding, so I would like to be

able
to

do it through the control source on the target field, if
possible.

Thanks in advance!

.