Combo Box NOT saving correct value

[supracharger]

I created a Combo Box that takes values from a table (EX. Linda, Hannah) and stores values in "Client Name". But instead of storing values(Linda, Hannah) in "Client Name" it stores Value (1, 2).

How do I get the combo box to store values (Linda, Hannah) and NOT (1,2)?


I tried Relating the tables from "ID" to "Clients Name" and rigging it to associate (Linda, Hannah) to (1, 2), but it didn't want to associate a "AutoNumber/ ID" to a "Text/ Clients Name". And gave me a Error Message, "Type Mismatch in Expression".

Thanx,
A.

[orange]

Please see the tutorial here
http://www.techonthenet.com/access/t...s/basics01.php

[supracharger]

If someone would help me out I would be Very thankful.
A>

[supracharger]

I Tried Rigging it again, and Creating a Query having (columns): ID, Client Name (Linda, Hannah), Client #:=[ID]+0. So every table would relate to this query using Client Name, and Client #, but it still gives me a Error message: "Type Mismatch in Expression".
Any help would be Greatly helpful,
A.

[orange]

Did you go thru the tutorial?

[supracharger]

I got it; I don't think you would be able to figure that out in a tutorial.
A.

[orange]

Well then, would you like to post a message telling others, who may have the same issue you faced, exactly how you solved it?
Others have had difficulty with combo boxes and still more will in future, so a brief description showing your solution would be very helpful.

[supracharger]

How I fixed it: Since it was storing the wrong value [ID], instead of the value that I selected [Client] in the combo box. I went in the properties/ Data and Found Bound column (I think) and it said 1. Under it I found it was making a SQL server, Columns: [ID], and [Client]. So what it was doing is showing [Client] 2nd column(2), and saving value [ID] 1st column (1).
FIX: So I had [Client] in Column 1, and also [Client] in Column 2, and moved [ID] to Column 3. And Now in the Combo box it shows [Client] and now saves value [Client].

A.

[Missinglinq]

And I'll bet you didn't know that the ID field was part of the Combobox, did you? If you generate a Combobox using the Wizard, and base it on one or more Fields of a Table, and that Table has an Autonumber/Primary Key Field, Access will automatically include the PK Field in the RowSource of the Combobox, even though you did not ask it to, and will make it the Bound Column, too boot!

Glad you got it working!

Linq ;0)>