Is Null - Microsoft Access Mailing Label Seminar


	Back to Access Mailing Label Seminar Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Is Null

Timothy Schmidt

3 years ago

Private Sub Command25_Click()
   Dim X As Long
   Dim L1 As String, L2 As String, L3 As String, L4 As String
   L1 = Nz(Line1, "")
   L2 = Nz(Line2, "")
   L3 = Nz(Line3, "")
   L4 = Nz(Line4, "")

DoCmd.GoToControl "Line1"

   /// For X = 1 To NumRec ///  This line is highligjted in yellow
    DoCmd.GoToRecord , , acNewRec
    Line1 = L1
    Line2 = L2
    Line3 = L3
    Line4 = L4

    Next
    DoCmd.GoToRecord , , acNewRec


End Sub

	Kevin Robertson @Reply 3 years ago
Since you haven't actually stated what the problem is I am assuming the reason the line is highlighted because NumRec hasn't been declared. If this is a Form field make sure it has a valid value.

	Timothy Schmidt OP @Reply 3 years ago
Thanks for replying, I found my error and it works just fine now. Thanks Tim

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Mailing Label Seminar.

Next Unseen

New Feature: Comment Live View