fish
03-17-2000, 09:52 AM
I have created six combo boxes on a form all linked to the same column of data from one table. I would like to have these combo boxes update every time a new entry is made on the form that is not already on the combo box list and then resort the updated list alphabetically. Right now I can add the new data onto the table and resort in the table but when I go back to the form the new data has been added to the combo box list but it has not resorted alphabetically as it did in the table. In the help menu it said that Access can only sort up to 255 characters in the combo box. Is there any way to increase the number of characters it will sort and to be able to update the list as new entries are made into the form and not have to also type them into the table in order for them to be added to the combo box list? You should know I am a beginner at Access and I do not know Visual Basic. I would appreciate any help. Thanks http://www.access-programmers.co.uk/ubb/smile.gif