Running Report from Query using Open Form or Entering Criteria

[AFuturePrez]

I am trying to run a report from the same query as the open form. I
want to use the form data to open the report, however, when opening
the report I need to enter criteria to open the form. I currently
have the following formula in the criteria section:

IIf([Forms]![RDC Hold Review (NE)]![UHN] Is Not Null,[Forms]![RDC Hold
Review (NE)]![UHN],[Enter Unique Hold Number:])

However, when running the report from the form, it still asks me for
the criteria.

Please help.

Thanks,

JMT

 

[John W. Vinson]

I am trying to run a report from the same query as the open form. I
want to use the form data to open the report, however, when opening
the report I need to enter criteria to open the form. I currently
have the following formula in the criteria section:

IIf([Forms]![RDC Hold Review (NE)]![UHN] Is Not Null,[Forms]![RDC Hold
Review (NE)]![UHN],[Enter Unique Hold Number:])

However, when running the report from the form, it still asks me for
the criteria.

Please help.

Thanks,

JMT

Try using a criterion

NZ([Forms]![RDC Hold Review (NE)]![UHN],[Enter Unique Hold Number:])

instead. I'm guessing that the IIF is parsing both arguments before returning
its result.

Better yet, why not just always use the form?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com