Yes, I did. The default value for first and last name are set in the query. I no longer get the "field cannot be update" message but when I click the command button to create a new record on the form, the "fullname" field still goes blank and it doesn't allow me to type anything in the box. Sorry, I'm still pretty new at Access.
Reply from Alex Hedley:
A record isn't created until you add some data You won't now need to type into the Full Name this will be created automatically Just add another field you would usually fill in.
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.