Solved: acces help

I've got an database, in this database there are made some callnumbers

this number is create like this:

customer # + Year + Month + number, this results in:

851000-2008-09-00001 (without the '-')

I would like to change this number so it wil create sequence per dealer, so when a other dealer is selected, the number re-starts with 00001, like:

851006-2008-09-00001

can anybody help with this?

Tnx,

Wouter

 

Wouter, is the current Number entered manually?
Are we talking about the Form called Form_Melding?

 

when selecting a dealer (field 'Dealernaam') in the form: FORM_Melding, the callnumber is entered automaticly

 

Wouter, I recognise the Code now, I created it a while back, so you want to carry on Incrementing the Count if the Dealer is the Same, but if it is a New Dealer start back at 00001?

 

Try this version, I am sorry, I had to delete your Images from the Forms to make it small enough to post on here. I am sure that you can put them back.

 

HI OBP,

Wow, thats fast! It's exactly what I needed.

MANY THANKS!

Wouter