Create report from current info on a form

[zachnjoe]

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?

 

[Duane Hookom]

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.

 

[Carma]

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.