How do you create a report using a form for the parameter?

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

Guest

I am trying to create a report that pulls information for an individual
student. I want the end user to choose a student's name from a drop down box
in a form (pulling from a Student table) and then from the form preview and
print the report. I've created a query that has a field SLName:
Forms!frmChooseStudent!Combo0 . I can use the form to choose a student and
then preview the report but the report shows the combo box number in the
SLName field instead of the actual student's last name. Does that make
sense? So, the report heading is: "Worksheet for 3" instead of "Worksheet
for Anderson". Can anyone help? I'm not sure if I'm doing this right.
Thanks!
 
one way is to put this student name into a table that has
a record nubmer of only one, ie the name, then link the
underlying query of the report to that table, works for me



(e-mail address removed)
 
Would this work?

SLName: Forms!frmChooseStudent!Combo0.column(1)

column(0) is what it is defaulting to, if the student's name is the 2nd column
in your combobox, then the above may work.


|I am trying to create a report that pulls information for an individual
| student. I want the end user to choose a student's name from a drop down box
| in a form (pulling from a Student table) and then from the form preview and
| print the report. I've created a query that has a field SLName:
| Forms!frmChooseStudent!Combo0 . I can use the form to choose a student and
| then preview the report but the report shows the combo box number in the
| SLName field instead of the actual student's last name. Does that make
| sense? So, the report heading is: "Worksheet for 3" instead of "Worksheet
| for Anderson". Can anyone help? I'm not sure if I'm doing this right.
| Thanks!
 
Back
Top