<div>
create a report with recordsource based on the recordsource of your form then use this codes<br />
<br />
docmd.openreport &quot;NameOfReport&quot;, acviewNormal,, &quot;[IdfieldName]=&quot; &amp;&nbsp;me.txtIdfield<br />
<br />
<br />
change [IdfieldName] with actula name of the field<br />
change txtIdfield with actual name of the control
</div>


create a report with recordsource based on the recordsource of your form then use this codes

docmd.openreport "NameOfReport", acviewNormal,, "[IdfieldName]=" & me.txtIdfield


change [IdfieldName] with actula name of the field
change txtIdfield with actual name of the control

<div>
I actually just want to print the form with the current record data included. &nbsp;I realize that a report would be better looking.
</div>


I actually just want to print the form with the current record data included.  I realize that a report would be better looking.

<div>
access report is not really for printing, you may not like the result.
</div>


access report is not really for printing, you may not like the result.

<div>
oops, that should be<br />
<br />
access FORM &nbsp;is not really for printing, you may not like the result.
</div>


oops, that should be

access FORM  is not really for printing, you may not like the result.

<div>
<div class="content wysiwyg-content">
I have a command button in the footer of a form. &nbsp;The form is Display View = Single Page.<br />
<br />
Even though the form has several records that can be navigated to, I want to print JUST the record being displayed. &nbsp;<br />
<br />
What would the onclick code of the command button be to accomplish this?
</div>
</div>


I have a command button in the footer of a form.  The form is Display View = Single Page.

Even though the form has several records that can be navigated to, I want to print JUST the record being displayed.  

What would the onclick code of the command button be to accomplish this?

Print current record displayed in the form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.