I setup the full name field in my query as instructed in this lesson, then added that field to my form. I then set a default value in the properties for that full name field to one employee so that he doesn't have to keep typing his name in the field for every record he adds. When I try to add a new record, though, Access opens a window that says, "Field cannot be updated." When I click okay, I can then continue on but the full name field is blank.
Reply from Alex Hedley:
Was it the Default Value you set or the Control Source? With it being joined you may need to set the Default Vaule of the First and Last name fields so the query joins them
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.