Access Projects: Referencing Form parameters from Reports

  • Thread starter Thread starter Keven Lonesome
  • Start date Start date
K

Keven Lonesome

Ladies & Gentlemen,

I'm trying my darnest to capture form input parameters
into my report selection criteria using Access projects.
using the syntax:
[FORMs]!Me!entry.date within Access reporting
is not accepted.

Note: I do not want to create a SP that embed its
parameters within the code to produce the report.
Instead, I want to capture the Form's parameters
to populate the criteria for the report.
(Some of my forms contain entering 3 to 5
parameters, most with date ranges)

Question: 1. Are there any conventional methods meeting
my requests
2. Do I have to create
@parameters within my SP report every time
to populate its report criteria?
(This method sounds real corny!)

Your correspondence will be highly appreciable!

Thanx.
..
 
Keven,

You're on the right track, I guess the problem is the Me. part in the
reference. Try absolute form referencing (by name), something like:
Forms!FormName!ControlName
This should work as long as the form is open at the time of running the
report.

HTH,
Nikos
 
Back
Top