Forms / Queries / Reports

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hello, I am a newbie asking for help. I have created a DB
with several tables that link to the main table.
Everything is working great so far. I have now created a
report that will open a form and ask for input. When
the 'OK' button on the form is clicked the form just goes
away. The selection information is passed to the query
but I can not seem to see why the report format will not
come back with the results.

Any and all help would be greatly appreciated!
Thank You in advance.
Jeff
 
Typically, the form would have a command button to open the report.
However, if you do not want to use a form, make the Query which is the
record source of your report a Parameter Query. With a Parameter Query, the
query will display a prompt asking the user for criteria and will deliver it
to the report.

Details on creating a Parameter Query are available in Access Help.
 
Cheryl, Thanks for the reply. I am still trying to
develop the DB as of yet. I will be adding a switchboard
that will have a reports sub-menu. On this sub-menu I
will have this report listed.

When I click this entry it will open the report. The
report has a form that will ask the user for input. As it
stands right now if I click the report it opens the form
to ask for input. When I enter the data and click
the 'OK' button the form just goes away. Then data that I
did enter does go to the query, I can go to queries and
see all the selected records. The problem that I am
having is that Access stops at that point. Access never
comes back and uses the query to populate the formatted
report so that it can be viewed or printed.

Not sure what I am doing wrong. Thanks for your help!
Jeff
 
Dear Jeff
Where you are going wrong, is that you need to call the
form from your menu, and not the report. Then on
the "Parameter" form, your OK button can open the report
(leaving the form open at this point). If your report runs
off the query, the query will run in the background,
taking the info from the parameter form, and then put it
into the report.

So in essence the sequence would be---
Click on report name in menu
Form pops up and asks user for info relating to the report.
User fills in the form and clicks OK
Form info sent to query
Report based on this query opens

Hope this helps

Paul
 
Back
Top