Since you didn't mention what to enter, I entered random things and usually got "no records found matching criteria" or similar.
Finally I just used blanks ... and was able to trap the error. The code is erring on this line:
Code:
Screen.ActiveForm.RecordSource = "Update Individual Account - NEW"
(clicking Debug will tell you that too...)
Which makes sense. Access can't find any table or query named "Update Individual Account - NEW", so the next thing it guesses is that the string is a SQL statement. Since it starts with UPDATE, Access thinks it is an Update query.
You also shouldn't be using Screen.ActiveForm. but rather explicitly referring to the correct form, or using a variable and setting it to a meaningful value. But anyway, that's not the immediate problem.
What DO you want to set the form's recordsource to?