<div>
you need to filter the report using the current record in the form.<br />
<br />
something like this<br />
<br />
docmd.openreport &quot;reportName&quot;,,,&quot;[CabID]=&quot; &amp;&nbsp;me.cabID<br />
<br />
see this link &nbsp;<a href="http://support.microsoft.com/kb/209560" rel="ugc nofollow">http://support.microsoft.com/kb/209560</a>
</div>


you need to filter the report using the current record in the form.

something like this

docmd.openreport "reportName",,,"[CabID]=" & me.cabID

see this link  http://support.microsoft.com/kb/209560 [http://support.microsoft.com/kb/209560]

<div>
<div class="content wysiwyg-content">
Good afternoon - I'm creating an Access database to generate cab vouchers. A user presses a button, and is brought to a blank form. Information is then entered. At the bottom of the form, I need a button that saves the record, then opens a report - this report is the cab voucher. Every time I press the button, I get every cab voucher in the database - not the one that has just been entered. <br />
<br />
How do I get the report to only generate the one record I just entered?
</div>
</div>


Good afternoon - I'm creating an Access database to generate cab vouchers. A user presses a button, and is brought to a blank form. Information is then entered. At the bottom of the form, I need a button that saves the record, then opens a report - this report is the cab voucher. Every time I press the button, I get every cab voucher in the database - not the one that has just been entered. 

How do I get the report to only generate the one record I just entered?

MS Access 2010 - a button that will save a record and open a report for that record

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.