Form to table help

[markyboy]

Ok i have a registration form which has the following text boxes
Firstname
Lastname
Username

The username text box is generated by this VB code which is entered in the "got focus" part of a CMD button. The command button was set up using the window which pops up when you first put it on the form and i used "add new record" option
I then want what is typed in these text boxes to go to the table of records

this is the VB used to generate the username
Me.Username = Left(Me.Firstname, 3) + Left(Me.Lastname, 1) + Str(DMax("right(Username, 3)", "table") + 1)


My question is that when i click the button it generates the username but then doesn't add it to the table


Does anyone know any reasons why this would happen or suggestions of how i could make it better bare in mind this has to be done in an exam so please no long VB code thanks you

[pbaldy]

For that to occur without code, the form would have to be bound to the table (record source) and the textbox would have to be bound to a field in that table (control source). Are they?

[markyboy]

For that to occur without code, the form would have to be bound to the table (record source) and the textbox would have to be bound to a field in that table (control source). Are they?

I hadn't but i have now and it works
Thank you so much

[pbaldy]

No problemo!