If Is Not Nul, i.e. if there is data in the field, then go to new record.

[Dave Elliott]

I need for this code to go to a new record if there is data, i.e. a customer
in the opening record.

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "BlankChecks"

If IsnotNull(Me.Customers) Then
DoCmd.GoToRecord , , acNewRec

End If

--


---------------------------------------------------------------------
This email and any files transmitted with it from Dave Elliott are
confidential and intended solely for the
use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the
sender.
All Mail is pre-scanned with Norton Antivirus 2004 for your protection.

http://[email protected]

 

[Van T. Dinh]

Try

If Not IsNull(Me.Customers) ...

HTH
Van T. Dinh
MVP (Access)