Re: Specify date criteria for subform data

Tech-Archive recommends: Speed Up your PC by fixing your registry

My inventory form and report(based on table ProductsSold) are working
perfectly. A new problem has appeared: when I use other forms based on
queries based on the ProductsSold table, I get the same parameter prompt:
enter paramater value
[Forms]![inventory]![unbounddate]
None of my forms is based on the table; all are based on queries based on
the table. However, the subforms on my inventory form have their own queries.
--
Thanks.
Sammie Access 2003


"John W. Vinson" wrote:

On Sun, 30 Mar 2008 20:31:01 -0700, Sammie <Sammie@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

Thank you, John. OK, that works on my form. Now to report on it. How do I
pass the unbound date value from my form to the report based on the form? In
design view, I saved my form as a report. I keep getting the following
parameter prompt when I try to open the report:
enter paramater value
=[Forms]![inventory]![unbounddate]
I want to pass the value automatically rather than entering it each time.

You can do so a couple of ways; the simplest by far is to put a command button
on the form to open the report, and leave the form open while the report is
printing (or previewing). If you close the form and open the report separately
you'll get prompted - but you shouldn't if the form is still open.
--

John W. Vinson [MVP]

.

Quantcast