Auto Number

[mithani]

Hello,

I have purchase order and I want everytime I make purchase order, system should give me last purchase order number + 1 automatically. How can I do?

Thanks

Mithani

 

[boblarson]

Use DMAX:

if as a controlsource of a textbox:
=DMAX("[YourPurchaseOrderNumberField]", "YourTableNameHere")

If in code

Me.YourTextBox = DMAX("[YourPurchaseOrderNumberField]", "YourTableNameHere")

 

[mithani]

Bob, appreciate your support. thanks

mithani

 

[boblarson]

Bob, appreciate your support. thanks

mithani

Glad to help when I can. I still have a lot to learn as well, but when I do know something (or THINK I know something) I post.

By the way, out of curiosity, where are you located?

 

[mithani]

thanks bob.

I was in Dubai for 12 years and now in Sydney Australia.

 

[boblarson]

I was curious as I find it very cool that this forum has people from all over.