Okay this is so simple I cant believe I cant do it myself.

I'm using an MS project with SQL server and I'm trying to create a form that'll take user first name, second name and password, then when they click a button it should close the form and combine first name and second name into a third field which will be their ID.

so say they put "chris" as their first name and "mawman" as their second name their ID would be "chrismawman" simple you'd think.

so I put PilotID = PilotFirstName & " " & PilotSecondName and then Form.Exit to close the form.

but when I try it out I get "The record set it not updatable" and it doesn't work. I've tried removing Form.Exit incase that was the problem but it doesnt seem to be. I cant understand whats going wrong.

Any help would be amazing.

It appears that you are doing it the right way. I would try to narrow it down and see if the problem is related to the SQL server use or a bug in your form/code. Using a make table query, make a copy of your SQL server table that will exist inside of your actual DB. Then alter your form & code to use the copied table and see if you get the same message.

BTW, did you get an error using Form.Exit? I tried to duplicate your problem and VBA didn't like Form.Exit. I used DoCmd.Close instead.