If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Create a report from a button?

Is it possible to create a report from a button. I have added a button to a form that queries specific information. Can i place a button below that one to run that query into a report. I looked through the button wizard and I can't seem to find what I am looking for.

In the the forms design mode you sould see (if its active) the toolbox.

Right hand side of that is the command button icon - click this and when the curser is moved over the form you will have a box outline. Left mouse click and the Button Wizard will place a button on the form.

The command button wizard will appear and will allow you to select the Report Operations - the right hand window will be the operations to :-
Mail Report - Preview Report - Print Report - Send Reporrt to File

select either Preview or print report, a list of the available reports will appear and then click on the one you want to print or preview thereafter you can select a name for the button or an icon

Originally posted by tjarvas
I am going to put the data from the query into the report. I want to query specific information from a table and present it in a report. If I can do this in one shoot, all the better.

Will the format of the report, or data ever change? I don't understand your response.

Assuming you only need to filter the data in report, via controls on a form, then you may pass parameters to the recordsource of a report.

Let me see if I can explain my project in a different way. I am building a database that hold inventory data. On a form I am allowing the user to query information by searching a table with a unique number. A few text boxes populate on the form for validation reasons. At this point the user add new information to that acct number. At this point the user presses a button that writes the updated information to a table. From this table I want to query specific information and show it in a report form. The layout of the report will never change but the data that the query will get will change. The main question is can I have a report that shows specific information from a table without running a query. If I do have to run a query to filter the data, is there a way to "one click" something to create a report with that queried data. I hope that this helps. Thanks for the patience.

Reports are generally based on an underlying query. So, conceptualize your report, then construct the query. Finally, build the report (either using the wizard or in design mode) with the Fields in view and place them where you want. The control source for the report (in the property box) should point to the underlying query.

When you then place a command button (as explained in a previous post) on the form, you can have it open this report.