Calculated field on form

  • Thread starter Thread starter Susan
  • Start date Start date
S

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!
 
Set this Control Source for your text box:
=IIf(([Field1] = True) AND ([Field2] = "FT"), "Yes", "No")
 
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!
Click to expand...


.
Click to expand...
 
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!
Click to expand...
Click to expand...
Click to expand...
 
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
Click to expand...
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
Click to expand...
able
to
do it through the control source on the target field, if
possible.

Thanks in advance!
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top