<div>
What about something like:<br><pre><code class="code-1 nolinks" id="code-20-43280396-1"><span>If Me.Previewed = 0 Then</span>
<span>&nbsp; &nbsp; DoCmd.OpenReport "rptLog", acViewPreview </span>
<span>Else</span>
<span>    'What to do if it was already previewed?</span>
<span>End If</span>
</code></pre><br>
</div>


SteveL13

<div>
<div class="content wysiwyg-content fr-view">
I have this code in the onclick event of a form...<br><br>DoCmd.OpenReport "rptLog", acViewPreview, , [Previewed] = 0<br><br>Meaning I only want the report to preview if the report has not already been previewed. &nbsp;But my code must be wrong. &nbsp;How do I fix it?<br><br>
</div>
</div>



I have this code in the onclick event of a form...
DoCmd.OpenReport "rptLog", acViewPreview, , [Previewed] = 0
Meaning I only want the report to preview if the report has not already been previewed.  But my code must be wrong.  How do I fix it?

How preview report if not already printed

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.