creating an ID number in access

[gem]

at the moment we have been given this problem where we have to incoporate a Dmax function into the following code



IDnumber = Left(Firstname, 3) + Left(Lastname, 2)

from this code the ID number creates something that looks like this

gembl

however i need a four digit number after this ID, for every different ID i need the numbers to increase by one the following code was given to us to do in Got Focus but this did not work

IDnumber = Left(Firstname, 3) + Left(Lastname, 2) + Trim(Str(DMax("right(IDnumber,4)","Customer tbl")+1))
Please help me

[orange]

You can do that, but

- is this for human communications and use
- is this to identify records for Access (because Access can use a different scheme very efficiently and guarantee unique numbers)
- is the increase by 1 for something special -- please describe

Why this particular setup is the basic question?

[gem]

Thank you for replying but I have solved the problem it ended up being as followed


Private Sub generateID_Click()
Dim TextPart As String
Dim NumberPart As String
'Check that the user has entered the required information
If IsNull(Firstname) Then Exit Sub
If IsNull(Surname) Then Exit Sub
If Len(Firstname) < 3 Then Exit Sub
If Len(Surname) < 2 Then Exit Sub

TextPart = Left(Firstname, 3) + Left(Surname, 2)
NumberPart = DMax("Right(ID_number,4)", "Customertbl")
NumberPart = NumberPart + 1
ID_Number = TextPart & NumberPart
End Sub


not simple but I got there in the end
It is for human use, but it is for my A Level Coursework

[orange]

Glad you have it working as you need.

One question -

Why do you use the + in this TextPart = Left(Firstname, 3) + Left(Surname, 2),
but the & in this ID_Number = TextPart & NumberPart