Print current record

[Fatboy Slim]

Im very new to access and the in program help as gone straight over my head..

My problem is to print a Report of all details in the current record..

An "Idoits guide" would be much appeciated..

Thanks in advance
Dave

 

[Pat Hartman]

Add a button to the form. The button wizard will walk you through the process. You will need to choose the options for Report and current record.

 

[Fatboy Slim]

Thanks for the information but its not quite what I wanted as it prints it as a graphic and i just want it to print the text.

Cheerz

 

[KevinM]

It looks like you are printing the actual form and not a REPORT of the records on the form.
Us the command button Wizard and chose print/preview report.

HTH

 

[Chris RR]

Maybe it would help to step back a minute...

First, a query. Sometimes you can just run with the query that your form is based upon. Otherwise, this may need to be a parameter query that will use some screen field (hopefully the record ID?) to select the right record(s). (Hint: Open the form, but keep it minimized while you're testing your query.)

Then create a report based on that query.

Finally, add a button to your form for the print.

 

[KevinM]

NO...

Using a parameter query will tie the report to that form and current record.
You are best using a WHERE clause in the Docmd.OpenReport line.
Your report can then be used throughout the db with different WHERE clauses on different forms or no where clause at all if you want the report to show ALL records.

HTH