>Greetings,
>
>So far I've been using drop down lists for user's to make choices from definition tables. The incremental search feature sure is nice.
>
>Now I have a situation where I want the user to easily add a value to both the list and underlying source table. If I use a combo, I can detect a new value and add it, but the incremental search feature, for existing values is lost.
>
>What are the ways that people handle this?
>
>TIA for any input...J
Since your incremental search list is probably populated by a view, you can add a record to your view that says
and make sure that whatever sort scheme you use for the list, the appears on top. If someone selects that value, it drops you off to an add form where you add just enough information to the table to select the item. You can do a complete edit somewhere else after you leave that routine. After the record is added, you requery the view and the new value is there.
HTH,
Bill
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!