Link to home
Start Free TrialLog in
Avatar of runner100
runner100

asked on

MULTICHOICE FIELD

I would like to know if it is posssible and if yes how.
I got a field with choice like company name you just choose the one you want but if it is not in the choice is it possible for a user to add a new company name with out going in the programmation of my form or table and in the same field is it possible to always have them automaticly organise in alphabetic order. ?
Avatar of Helicopter
Helicopter

If your list is bound to a table then you will at some point need to add the new item to that table and requery the list.

If your list is simply a list of values you have typed in then I suppose theoretically it would be possible to change the row source by adding a new item to the string, but I don't think the information would be stored between sessions.

The alphabetical thing is just an order by clause in your underlying query. Adding a new item is not difficult, there is a good example of it in the solutions database
ASKER CERTIFIED SOLUTION
Avatar of KimD
KimD

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial