[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MULTICHOICE FIELD

Posted on 1998-11-22
2
Medium Priority
?
235 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
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

872 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