Passing data to report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have followed the "Create a form to enter report criteria" in MS Access's
help file, but can not get the data collected on the form to work in the
report. Thanks in advance.
 
Hmmm? When I follow the information in help, it worked.

Could you describe what happens when it doesn't work? For example, how are
you telling your report to use the data on the form? Are you using a query
to refer to the form's data, or are you referring to it directly from your
report definition?
 
First I get an eror that states an error accessing file for the "OK" macro
being called by the OK button set as "SetValue" action as [visible]
expression "No"... when I am trying to restrict the report to include only
one person's name and also a date selection. I think I am messed up in the
query, because when I put "Between [Forms]![Report Criteria]![BeginningDate]
And [Forms]![Report Criteria]![EndingDate]" and "WHERE [Technician Name] =
Forms![Report Search Selection]![Findtech] "... It adds a field column of
"WHERE [Technician Name]" and prompts for the Beginning date and endingdate.
ARggghhhh! I am so dumb! ~L~
 
One step at a time...

Can you get the query to work if you "hard code" values instead of
[parameter]s?

Once the query is working, open the form, set some values, and re-design the
query to use the form's values as parameters.

When that's working, try to open your report, based on the query.

Good luck

Jeff Boyce
<Access MVP>

truepantera said:
First I get an eror that states an error accessing file for the "OK" macro
being called by the OK button set as "SetValue" action as [visible]
expression "No"... when I am trying to restrict the report to include only
one person's name and also a date selection. I think I am messed up in the
query, because when I put "Between [Forms]![Report Criteria]![BeginningDate]
And [Forms]![Report Criteria]![EndingDate]" and "WHERE [Technician Name] =
Forms![Report Search Selection]![Findtech] "... It adds a field column of
"WHERE [Technician Name]" and prompts for the Beginning date and endingdate.
ARggghhhh! I am so dumb! ~L~




Jeff Boyce said:
Hmmm? When I follow the information in help, it worked.

Could you describe what happens when it doesn't work? For example, how are
you telling your report to use the data on the form? Are you using a query
to refer to the form's data, or are you referring to it directly from your
report definition?

--
More info, please ...

Jeff Boyce
<Access MVP>
Click to expand...
Click to expand...
 
Back
Top