Displaying Query Results in a Report

  • Thread starter Thread starter Jess A
  • Start date Start date
J

Jess A

I am trying to create a report based on a query. I have a form with
unbound text boxes, one for last name (whatPerson) and one for meeting
name (whatMeeting). The form has a command button that runs a macro
(macro_search) that opens a query (qry_search). If the user enters a
last name into the search form, the results will display that person's
contact information as well as all of the meetings he/she attended. If
the user enters a meeting name, the results will display all of the
people that attended that meeting along with their contact
information.

I would like to get the results to display in a report that is easy to
print out. I have tried to create a report with a record source that
points to the query, and have the command button run a macro that
opens that report, but when I do this, a prompt pops up asking for
criteria. Also, behind that prompt, I see a box saying it is printing
something. Am I going crazy? I feel like I am missing a step or
perhaps designing the elements in the wrong way.

I am new to Access and would appreciate any help!
 
When you get the prompt that asks for criteria try entering a last name or a
meeting name
and see whether your report looks as you intended. Once you have the report
layout you want
set the criteria in the underlying query to the value of the text box on
your form.
For instance, assuming your form is called frmMeetingDialog and the text box
for LastName on the form is Text2, the criteria box
in the LastName field of your underlying query would be populated with
[Forms]![frmMeetingDialog]![Text2].
Hope that helps and I hope I'm right (fingers crossed).

Ed
 
Back
Top