i would like a message to appear that says 'user not found, would you like to create a new user?
Then alter the msgbox part of what you were given. Have you researched the message box function? Could spoon feed you I suppose, but it's very basic stuff that you should learn.
Only suggestions I'd add to the above is to test (in the control BeforeUpdate event) whether or not the count = 0 then present the message and if >0 do nothing (Exit Sub). If 0 then present the option to add or not. If not, cancel the update.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.