Drop Down Box Populated with Query

abby_1309

Registered User.
Local time
Today, 11:59
Joined
Mar 11, 2009
Messages
15
Hello Guys..i will be very thankFul if u can help me
I Have a Drop Down Box.Which is Populated with a Query.Problem is I acn See the Name in Drop Down but i cant Select any one other the one on Top and secondly when it saves it in Table it saves the Key Value against that Name not the Actula Name..can u help me with that plz..its reall urgent for me
 
So long as the field which the combo is bound to is the correct datatype to store a name (text) then you could likely change the bound column property of the combo box.

With the form in design view, select the combo, open the properties (right click on the combo and choose 'properties'), Look for the Bound Column row, and change the 1 to a 2 (or if there are more than two columns in the row source (query) of the combo's drop down list then you may need to adjust the number so that it aligns with the column that contains the names.
 
1. It SHOULD be saving the ID and not the name. That is part of a properly normalized database. You can get the values by using QUERIES and not tables directly.

2. Probably because your table is not set up properly and you have a key or index set that will not let anything be in there except what is there for the first record.

I would suggest posting your database for us to look at, if you want a quick resolution.
How to post a database to the forum
 
And yes, Bob is entirely correct. In a properly normalized design, you should be storing the key value :D
 

Users who are viewing this thread

Back
Top Bottom