How To Save Record and Create Print Preview with same button on a form

[wes9659]

In Access I have created a button to print a preview prior to printing document it is entitle "NoVeteranMain" which works fine. Except I want it to save my document prior to printing preview how would I do it. If not after I edit it I have to re-save it prior to hitting button which generates print preview.



This is code that is generate upon click
Private Sub NoVet_Click()
DoCmd.OpenReport "NoVeteranMain", acViewPreview, , "ClientID = " & Me.ClientID
End Sub

[pbaldy]

Add

If Me.Dirty Then Me.Dirty = False

[wes9659]

here is screen shot got errors

[rpeare]

try it with a carriage return after the statement pbaldy gave you

if me.dirty then me.dirty = false
<YOUR CODE HERE>

You may need to issue a me.refresh command before you run your report too especially if you are doing a print preview on a record that was just added. Depends on the structure of your data/data entry though.

[wes9659]

Works Perfect Thanks Everyone for all your help

[pbaldy]

No problem.