asked on

Combobox entries

Is there a way to allow a user to enter a value in a combobox that isn't in the query, therefore in the table, that the user sees when they look at the drop-down list of values? I know they can add to the list if I provide a form to add a value with.

But is there a way they can add to the list "on the fly" without being taken to the form first?

SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SteveL13

ASKER

You have both done a great job of convincing me that I should not go this route. Thank you once again for the support.

Jeffrey Coachman

;-)
Thanks

It's not that you shouldn't, ...its just that it can lead to problems...
If you have very high level users (For example, 4 elite sales people who know your customers) then adding a customer on the fly would be OK...
But if you have low level users who are looking for the product: "1llIi1O0O00li1l", and they miss-read it, ..then they will think they have to add it...
...I am sure you can see what that might lead to...
;-)

In the end it is always good to know the technique, just in case...
;-)

Jeff