F
Frank Situmorang
Hello,
Currently, I have an autonumber Primary key and my database is running well
with many forms.
Now I want to change the Primary Key of member table to showup like thisL
8321 and the next digit is always +1.
So 1st records will show 83210
2nd recrod will show 83211
3rd record will show 83212.
Can we make it on the textbox control of the form to have default value to
start with number 8321....?
Can we make it with the =Nz(DMax("[YourField]","[YourTable]"....= " &
0) + 1
I do not know exactly the VBA for this.
Thansk for any idea.
Currently, I have an autonumber Primary key and my database is running well
with many forms.
Now I want to change the Primary Key of member table to showup like thisL
8321 and the next digit is always +1.
So 1st records will show 83210
2nd recrod will show 83211
3rd record will show 83212.
Can we make it on the textbox control of the form to have default value to
start with number 8321....?
Can we make it with the =Nz(DMax("[YourField]","[YourTable]"....= " &
0) + 1
I do not know exactly the VBA for this.
Thansk for any idea.