Printout action

[Betty]

I'm using the printout action. I enter my information on the form and print
off of the report but with the printout action it prints off of the form.
How can I get it to print from the report? I want to print the current
record. Thank you.

 

[Al Campagna]

Betty,
You have to create a Report, and in your macro call the PrintAction against that
Report... not against the Form.

 

[Betty]

Thank you. I have a report and it still isn't working right. Do you have any
other ideas? Thanks

 

[Al Campagna]

Betty,
You wrote,That really doesn't tell us anything...

In the query behind your report, there should be a unique key field value that
identifies each record. That's part of good table design.
Leaving your form open, and requesting the report to print from there... you would use
the key value from the open form to filter the report so that only that one record is
returned.
The criteria for your key field (ex. CustID) would be...
= Forms!frmYourFormName!YourKeyFieldName

If you were viewing CustID 12345 (John Smith), and use that CustID to filter the
report, then only the information for John Smoth will be returned by the report.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Betty]

I'm real new to access so how would I do this? Thank you very much.

 

[Al Campagna]

Betty,
That's really too broad a question to answer within the context of a newgroup.
Basically, it's the same process you used to develop your form.
Use a table or query (preferrably a query) as the record source for the report, and lay
out your fields and controls the same way you did for your form.

You'll have to get to the point where you have a report that returns "all" your table's
records properly. Then, you can apply the filtering technique I laid out in the previous
post to print just the record displayed on the open form.

In other words, post back when you're question is more specific...
"I have a report that prints out "all" my records correctly... how can I get that
report to print just the record I'm looking at on my form?"

And, when you are that point, and if you still have problems, post back... and please
include the form name, report name, key field name, and any other relevant information.