Hi

Hope someone can help me. I'm trying to set up an order from in Access 2003
and being very rusty have been using a Microsoft template.

I am setting up an employee ID box that I want to show the employee name:

I have a qry (Expr1: [LastName] & "," & [FirstName]) that has added the first
and last name together and it appears on the form in the correct format but I
immediately get an error message : The value you added isn't valid for this
field. I have set up the qry against the * not employee ID.

The PK is Employee ID.

I have the same issue with Customer ID.

Am sure this is something simple that I have overlooked.

Thanks
Diane