It was the default value in the text box properties of the "FullName" field. The control source is "FullName" and it gets that from the concatenated field I set up in the query. I tried to set the default value of the first and last name fields but with the same effect. Thanks for your help.
Reply from Alex Hedley:
Did you remove Default Value of the FullName and just set First/Last?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 9.