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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Create report from current info on a form
People fill in info on a form and some would like to print the info. Some
have tried print screen but it gives mixed results. I tried to create a report using the current data in the form but the report wizard only allows reports generated from tables or queries. What is the best way to achieve this? |
#2
|
|||
|
|||
Create report from current info on a form
You didn't say what was wrong with using records from a table or query. Is
the form bound to a table or query? Are the control bound to fields in a table or query? You can create a report that is not bound to any table or query but the wizard would be worthless if this were the case. -- Duane Hookom Microsoft Access MVP "zachnjoe" wrote: People fill in info on a form and some would like to print the info. Some have tried print screen but it gives mixed results. I tried to create a report using the current data in the form but the report wizard only allows reports generated from tables or queries. What is the best way to achieve this? |
#3
|
|||
|
|||
Create report from current info on a form
zachnjoe wrote:
People fill in info on a form and some would like to print the info. Some have tried print screen but it gives mixed results. I tried to create a report using the current data in the form but the report wizard only allows reports generated from tables or queries. What is the best way to achieve this? What you could do is create a query based upon the table where the form stores the data. But filter the query to only give the record for the one currently selected on the form. Then create a report based upon this query and have a button(or something else) on the form to take users to the report. Or you could make the button just simply print the report instead. The only problem I see is that the user may have to create the record first, then come back and reselect it but you'll have to test that out. This way would allow users to print the info on any one particular record. You could also create a button/report which would allow user to preview/print a report of all records if they like. |
Thread Tools | |
Display Modes | |
|
|