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


What about something like:
If Me.Previewed = 0 Then
    DoCmd.OpenReport &quot;rptLog&quot;, acViewPreview 
Else
    &#39;What to do if it was already previewed?
End If

How preview report if not already printed


I have this code in the onclick event of a form...
DoCmd.OpenReport &quot;rptLog&quot;, 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?

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.