Solved

MULTICHOICE FIELD

Posted on 1998-11-22
2
229 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

732 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