By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,160 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Creating running number for my Invoice

P: 1
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.InvoiceNo) 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
Nov 3 '08 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
Your code has to go in between these 2 lines:

Private Sub Form_Load()

End Sub
Nov 3 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.