Creating running number for my Invoice

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • wenzhou748
    New Member
    • Nov 2008
    • 1

    Creating running number for my Invoice

    I created an event on the Main form's property 'On Load' as below, but on opening the form I got error msg "The expression On Load you entered as the event property setting produced the following error: Invalid outside procedure.
    Can you tell me is the problem. I'm using Access 2002.

    If IsNull(Me.Invoi ceNo) Then
    Me.InvoiceNo = Forms![frmInvoice]![frmIncrement].Form![Increment]
    Forms![frmInvoice]![frmIncrement].Form![Increment] = Forms![frmInvoice]![frmIncrement].Form![Increment] + 1

    End If


    Private Sub Form_Load()

    End Sub
  • puppydogbuddy
    Recognized Expert Top Contributor
    • May 2007
    • 1923

    #2
    Your code has to go in between these 2 lines:

    Private Sub Form_Load()

    End Sub

    Comment

    Working...