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
|
|||
|
|||
Dropdown: easy way to detect if item is in the list?
Hi
Is there an easy way (eg property) for dropdown boxes to determine if the user entered a value already in the list? The user is permitted to select existing items in the list OR type new ones. Limit to list is false. If the user starts typing and the autofill gives them the entry they want, OR if they select the entry using the dropdown and selects the item I would like a quick way to know. I am wanting to avoid having to write an after update query to go looking for that entry to tell me if it is new. Another question. The drop box has 5 or so columns. If the user types a new entry into the drop box, what values does Access give to the other 4+ columns, are they null? Thanks in advance AC |
#2
|
|||
|
|||
Dropdown: easy way to detect if item is in the list?
If a user enters a value that is not in the list, the NotInList Event will
fire, so your reall don't have to do anything if they select an item in the list other than the usual code to make the record referenced by the combo box the current record. The combo box does not have an entry in the list for new items until your put them where the rowsource for the list is and requery the combo, so none of your columns will have any value. The purpose of the NotInList event is to allow you to take the action you need to add the new data for the list. "A C" wrote: Hi Is there an easy way (eg property) for dropdown boxes to determine if the user entered a value already in the list? The user is permitted to select existing items in the list OR type new ones. Limit to list is false. If the user starts typing and the autofill gives them the entry they want, OR if they select the entry using the dropdown and selects the item I would like a quick way to know. I am wanting to avoid having to write an after update query to go looking for that entry to tell me if it is new. Another question. The drop box has 5 or so columns. If the user types a new entry into the drop box, what values does Access give to the other 4+ columns, are they null? Thanks in advance AC |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
HELP! Nesting IF Statements/Dependent Dropdown List | Thomas Peters | Worksheet Functions | 4 | November 30th, 2005 05:38 PM |
Dropdown List Error | cpr | General Discussion | 4 | June 18th, 2005 06:05 PM |
Creating a dropdown list | Jaywright | General Discussion | 1 | June 8th, 2005 11:53 PM |
How do I get a list to default to the first item? | QTP Professional | General Discussion | 2 | October 27th, 2004 11:25 PM |
Add Item from one listbox to the next | alex pLEASE HELP | General Discussion | 0 | July 22nd, 2004 08:53 PM |