Refering to fields on master from from subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

magmike - 27 Nov 2007 16:21 GMT

I have a text box on a subform, that I am using an IIf statement in,
so that if the field ([IUSA]) on the parent form Is Null, returns "No
data for this record", else returns "IUSA Data" as a caption.

The code:
=IIf([Form].[ProspectForm].[IUSA] Is Null,"RefUSA record not
connected","RefUSA Data")

Am I referring to the field on the parent form (ProspectForm)
incorrectly, because it isn't working? It returns #Name?

thanks in advance!

magmike

Reply to this Message

Klatuu - 27 Nov 2007 16:33 GMT

Where you have form, it should be forms:
=IIf([Forms].[ProspectForm].[IUSA] Is Null,"RefUSA record not

> connected","RefUSA Data")

If that doesn't cure it, try this version:

=IIf(Me.Parent.[IUSA] Is Null,"RefUSA record not

> connected","RefUSA Data")

Signature

Dave Hargis, Microsoft Access MVP

> I have a text box on a subform, that I am using an IIf statement in,
> so that if the field ([IUSA]) on the parent form Is Null, returns "No
[quoted text clipped - 10 lines]
>
> magmike

Reply to this Message

magmike - 27 Nov 2007 20:51 GMT

> Where you have form, it should be forms:
> =IIf([Forms].[ProspectForm].[IUSA] Is Null,"RefUSA record not
[quoted text clipped - 24 lines]
>
> - Show quoted text -

I see. Mistake was the missing letter. Thanks!

Reply to this Message