Increase a No automatically when creating a new invoice

When I create a new invoice I would like the new no. to come on my form
automatically. It reads the last InvNo and adds 1 to it and displays it on
the screen. Can somebody help me do this?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9862-increase-no-automatically-when-creating-new.html
Thanks
Dan

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Best to do this in the BeforeUpdate event of the form. That's the last
possible moment you can assign the number before the record is saved. This
timing reduces the chance that 2 users who are both entering data will be
assigned the same number.

Set the BeforeUpdate property of the form (not that of a control) to:
[Event Procedure]

Click the Build button (...) beside this.
Access opens the code window.

Between the "Private Sub..." and "End Sub" lines, enter:
Me.[InvoiceID] = Nz(DMax("InvoiceID", "tblInvoice"), 0) + 1

Replace InvoiceID with the name of your number field, and tblInvoice with
the name of your table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9862
Reply to group, rather than allenbrowne at mvps dot org.

"danh" wrote in message
news:764EB741-DAA0-427E-ACE2-04F2C0367C7B@microsoft.com...
> When I create a new invoice I would like the new no. to come on my form
> automatically. It reads the last InvNo and adds 1 to it and displays it
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9862
> on
> the screen. Can somebody help me do this?
> Thanks
> Dan

The autonumber field in Access would be your best bet..
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9862

you can access this through the design of your table , you would have
to change your invoice no field
then you can reference that field on your form

Cheers

ads

Thanks so much Allen. I will try it.

"Allen Browne" wrote:

> Best to do this in the BeforeUpdate event of the form. That's the last
> possible moment you can assign the number before the record is saved. This
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9862
> timing reduces the chance that 2 users who are both entering data will be
> assigned the same number.
>
> Set the BeforeUpdate property of the form (not that of a control) to:
> [Event Procedure]
>
> Click the Build button (...) beside this.
> Access opens the code window.
>
> Between the "Private Sub..." and "End Sub" lines, enter:
> Me.[InvoiceID] = Nz(DMax("InvoiceID", "tblInvoice"), 0) + 1
>
> Replace InvoiceID with the name of your number field, and tblInvoice with
> the name of your table.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "danh" wrote in message
> news:764EB741-DAA0-427E-ACE2-04F2C0367C7B@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9862
> > When I create a new invoice I would like the new no. to come on my form
> > automatically. It reads the last InvNo and adds 1 to it and displays it
> > on
> > the screen. Can somebody help me do this?
> > Thanks
> > Dan
>
>
>

Thanks so much ads but it I didn't want to use the Autonumber as I want the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9862
invNo to follow each other.

"ads" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9862

> The autonumber field in Access would be your best bet..
>
> you can access this through the design of your table , you would have
> to change your invoice no field
> then you can reference that field on your form
>
> Cheers
>
> ads
>
>