Order Form - Issue with Fields set up as combos

[DianeC]

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

 

[John W. Vinson]

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!