Customer Number Generator

[jcarroll3102]

I am trying to create a database that has a form with customer number, customer name, amount, and date.

I need the loan number to be automatically generated 10 digits. Digits 8 and 9 need to be 12 more than the previous number. The tenth digit needs to be Zero if sum of digits 1-9 are even, five if sum is odd

Ex: 1100012340
1100012465

This is my first Access post, I would appreciate any help you guys could provide

 

[jcarroll3102]

No, gaps are not a problem. How would I force the user to save the record once the ID is generated?

 

[SydneyGeek]

Insert this line after you have populated the ID:

RunCommand acCmdSaveRecord

Denis

 

[jcarroll3102]

You are my hero! I tested that out with a couple people over the network and seems to be working just fine. Now its a matter of training everyone to use it,

 

[SydneyGeek]

Glad it's sorted

Denis