Hello to all experts out there!

I'm pretty new to VB for access and I need some help from you guys.
I would like to use my database (access 2000) in a multiuser environment and my form should give the user the next serial number on the new record whenever the form is open or when a new record is added.

Are there someone who can help me with this. Thanks