Group: microsoft.public.access.reports
From: =?Utf-8?B?U3VzYW4gTA==?=
Date: Tuesday, October 23, 2007 10:04 AM
Subject: Syntax for obtaining a value from one subform to another

I should be able to figure this out, but...so far no luck with the syntax.

I have a main report that contains several subreports. On one subreport
(subrpt1), there's a value (-1,0) in a control called NoAutoInterface. I want
an unbound text box in the footer on subrpt2 to use that value to determine
whether a message should appear. The following syntax (among others I've
tried) is not working.

=IIf([Reports]![mainrpt].[subrpt1].[Report]![NoAutoInterface]=-1,"This state
has requested no automated interfaces for testing.","")

Any suggestions?
--
susan