printing

[ppoole16]

I need help with printing the information in an open form as a report. I only want the current record to print as a report opposed to all of the records. I'd just print the form but the form takes up way more paper.

I was also wondering how to get the gridlines in the report to print?

Thanks in advance.

 

[WayneRyan]

ppoole,

DoCmd.OpenReport "YourReport",,,"[SomeField] = '" & Me.SomeField & "'"

This assumes that the field you are looking for is a string.

Wayne

 

[Autoeng]

Depending on your expertise Wayne's explaination might be a little vague. Here's more detail...

http://www.access-programmers.co.uk...?s=&threadid=44006&highlight=print+one+record