Hi Guys!

I need some help here...

I am still learning vb. I wana generate a 7 digit code (YY-nnnnn) where YY is the current year and nnnnn is an auto-increment number. I am gona use this as a primary key.

Hope someone can help me with my dilemma.

Thanks a lot!