?
Solved

MULTICHOICE FIELD

Posted on 1998-11-22
2
Medium Priority
?
231 Views
Last Modified: 2010-05-18
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. ?
0
Comment
Question by:runner100
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Expert Comment

by:Helicopter
ID: 1969043
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
0
 
LVL 1

Accepted Solution

by:
KimD earned 0 total points
ID: 1969044
If your list is a combo box based on a table or query you could do the following:

1. set your combo box to Limit to List

2. Create a form for your users to add information for the new company (company input form).

3. On your combo box use the On Not In List event to open the company input form. Once the user inputs all relevant info and closes the form the original form get the focus.

4. When your original form gets the focus you requery the combo box.

If the combo box is based on a query, set the Company Name field to sort ascending.

Hope this helps
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question