Concatenate values of four TextBoxes into one TextBox

[Oblvion]

to concatenate first value from first 3 textboxes
and year value from fourth textbox
for LED1962 to display in MemberID textbox

L from Littlejohn (txtlastname textbox)
E from Eugene (firstname textbox)
D from Dale (middlename textbox)
1962 from Year (birthyear textbox)

 

[Oblvion]

i solved my own problem...

Private Sub cmdBirthDateAutoFill_Click()

MemberID = Left([Last], 1) & Left([First], 1) & Left([Middle], 1) & [BYear]

End Sub