Printing Reports From a Form

[bikeshox13]

I have a Form that has a button that will print a report only for the current record displayed on the form. The button works great except for when entering a new record. I have to go to a different record and then come back to the new record in order for the record to print. I'm guessing i need something to update the report when clicking the button. Any ideas? Here is the code for the button.

Private Sub btnPrint_Click()
'Print current record
'using CAR Number.
If IsNull(Me![CARNUM]) Then
MsgBox "Please select a valid record", _
vbOKOnly, "Error"
Exit Sub
End If
DoCmd.OpenReport "rptPrintCurrent", , , _
"[CARNUM] = " & Me![CARNUM]
End Sub

 

[Taruz]

Hi..

Use this command..

form.refresh
If IsNull(Me![CARNUM]) Then
MsgBo....
.................