Posted on 1998-11-22
Medium Priority
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. ?
Question by:runner100

Expert Comment

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

Accepted Solution

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

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

600 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