If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo Box - shouldn't I be able to enter an item not listed?
I thought the combo box was supposed to allow one to enter new data that
isn't on the existing list? When I try to do this I get a pop-up error telling me to select an item on the list. What am I doing wrong? I need to be able to select from the list OR enter a new item to be added to the list. The list comes from the table. |
#2
|
|||
|
|||
Combo Box - shouldn't I be able to enter an item not listed?
Chip wrote:
I thought the combo box was supposed to allow one to enter new data that isn't on the existing list? When I try to do this I get a pop-up error telling me to select an item on the list. What am I doing wrong? I need to be able to select from the list OR enter a new item to be added to the list. The list comes from the table. Either the LimitToList property is set to Yes or you have a ComboBox that displays one column while having another one that is bound. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Combo Box - shouldn't I be able to enter an item not listed?
On Wed, 31 Oct 2007 19:20:01 -0700, Chip wrote:
I thought the combo box was supposed to allow one to enter new data that isn't on the existing list? When I try to do this I get a pop-up error telling me to select an item on the list. What am I doing wrong? I need to be able to select from the list OR enter a new item to be added to the list. The list comes from the table. If the Combo box's LimitToList property is set to Yes you can only select an item in the list. You can place code in the Combo's NotInList event to allow for the addition to the list of a new entry. Search http://www.goups.google.com for "NotInList" for examples of how to do this. There are several different methods. Which is best for you depends upon what else is needed. If you don't wish to limit data to what is on the list, set the LimitToList property to No. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#4
|
|||
|
|||
Combo Box - shouldn't I be able to enter an item not listed?
Excellent. Now for a problem that popped up when entering new data -
I have the dropdown list working, I select a band from the list and it populates the band name field like it should. Problem is it is also generating a new band id for every entry I make, and it shouldn't do that. Each band has it's own id, but each album entry has an id of it's own. How do I get it to maintain the proper band id that is already associated with it and not create a new one? |
#5
|
|||
|
|||
Combo Box - shouldn't I be able to enter an item not listed?
=?Utf-8?B?Q2hpcA==?= wrote in
: Excellent. Now for a problem that popped up when entering new data - I have the dropdown list working, I select a band from the list and it populates the band name field like it should. Problem is it is also generating a new band id for every entry I make, and it shouldn't do that. Each band has it's own id, but each album entry has an id of it's own. How do I get it to maintain the proper band id that is already associated with it and not create a new one? Set limit to list to yes, and use the NotInListEvent. What is happening is that a typed in "The Band" has no id, versus :The Band" selected by clicking which already has an ID. Access is getting confused. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com |
Thread Tools | |
Display Modes | |
|
|