From: DianeC on
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

From: John W. Vinson on
On Sun, 16 May 2010 20:22:31 GMT, "DianeC" <u60111(a)uwe> wrote:

>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

Bear in mind that the ID is almost surely a Number, and "Smith, David" is not
a number and will not match an ID, and cannot be stored in an ID. This is true
even if you've fallen victim to Microsoft's confusing "Lookup Field" so-called
datatype; this will *conceal* the actual numeric content of the ID field
behind a combo box displaying a name.

Please open your query in SQL view and post the SQL text here. My guess is
that you're trying to store the text into a number field but that's not clear.
For one thing, you can't apply a criterion to * so I'm not at all sure what
you mean!
--

John W. Vinson [MVP]