J
JL
Hi,
Hope I can get some help because I'm really stuck with this one.
I created a form from Table1 that aks for Beginning Date / Ending Date /
Vendor.
I created a query from same Table1 with the following arguments.
Under Date: Between [Forms]![Name of Form]![Beginning Date] And
[Forms]![Name of Form]![Ending Date]
Under Vendor: [Forms]![Name of Form]![Vendor]
When I run the query it brings up a prompt asking me for Beginning Date /
Ending Date / Vendor and the result is exactly what I need.
The form seems to be OK as well, all selections are unbound. I'm also
running a Macro that defines Open/Close/Cancel and it too seems to be working
OK.
When I select the report it takes me to the correct form and it asks for the
fields that I need. This is where I'm encountering the problem.
1. The cancel button does not cancel but moves me into the report.
2. (The big problem) The report I get includes every single entry,
regardless of what I specified in the Form fields.
I know that it is probably a simple step that I'm missing but I've been
looking at this for so long that I no longer know what's right or wrong.
Hope I can get some help because I'm really stuck with this one.
I created a form from Table1 that aks for Beginning Date / Ending Date /
Vendor.
I created a query from same Table1 with the following arguments.
Under Date: Between [Forms]![Name of Form]![Beginning Date] And
[Forms]![Name of Form]![Ending Date]
Under Vendor: [Forms]![Name of Form]![Vendor]
When I run the query it brings up a prompt asking me for Beginning Date /
Ending Date / Vendor and the result is exactly what I need.
The form seems to be OK as well, all selections are unbound. I'm also
running a Macro that defines Open/Close/Cancel and it too seems to be working
OK.
When I select the report it takes me to the correct form and it asks for the
fields that I need. This is where I'm encountering the problem.
1. The cancel button does not cancel but moves me into the report.
2. (The big problem) The report I get includes every single entry,
regardless of what I specified in the Form fields.
I know that it is probably a simple step that I'm missing but I've been
looking at this for so long that I no longer know what's right or wrong.