how do i pass value from form to query parameter when opening report

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

I have a Form (frmBlankEvaluation) that is built on a query
qryEvaluationsBySupervisor

When you open the frmBlankEvaluation it prompts you to input the
"evaluator" name
e.g "Schmoe"

This will pull up a evaluation form for each person that Schmoe has to
complete. You type in your ratings and then when you close this form..
it will open a report for previewing before you print off the
evaluations.

How do I grab the "evaluator" and pass it to the query that the report
is based on? So the db user doesn't have input "Schmoe again to open
the report (rptEvaluationsCompleted).

Or would it just be easier to print right out of the form
(frmBlankEvaluation) ? The reason I haven't printed out of the form
is that somehow the pages are messed up ... where page 1 will contain
the first evaluation and a portion of the second evaluation. They are
out of alignment as single pages for each evaluation. ???

TIA,
_Bigred
 
Instead of having the query ask for the name, put a combo box on your form
that gives you a list of the names, and let the person select the name. Have
your query read the value it needs from that combo box. Use the combo box's
AfterUpdate event to requery the form. Then have the report's query also
read the value it needs from that combo box.
 
Ken answered most of this, but didn't address the issue of your report having
more than one evaluation on the same page.

You probably need to add a Grouping to your report. Since I don't know your
field names, I will assume that you have some sort of EvalID, with is
specific to both the evaluator and the evaluatee. Use this as your Group
identifier. You don't have to put anything in the group header or footer,
but highlight the group footer, then in the properties window look for the
"Force New Page" property, and set its value to "After Section". What this
should do is only display a single evaluation on each page of the report.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Back
Top