Combo Box Multi Selections?

[lboria]

I would like to select multiple records from my combo box not at the same time but each selection to be added to another text field in my form.

PROBLEM: When I select a record that 1st selection is populated in the other text field however when I want to select another choice to be added with the 1st choice the selection overwrites the 1st choice instead of adding to it.

 

[Crilen007]

hmm..
So, you cant use a list box to select multiple at the same time?

That would be the easier way.


Only thing I can think of, is when they click something, it stores that in a VB variable, and places that variable into the box. When they click something else, it adds to that variable, and again places it into that box.

So you would have to create a global variable i think, and set it to nothing, and on the "onclick" event, have

globalvariable = globalvariable & "string of text"

 

[lboria]

Thanks for the info however I wanted to use a combo box instead of a list box.

Please see attached PDF file which contains screen shot and description.

Click Here to Download PDF

Thanks

 

[Crilen007]

I know, my idea was for just about anything you wanted to use.

You could use text box and a button and my proposal would still function as needed. I think...

Perhaps a before and after would help if I am still wrong.

 

[Pat Hartman]

I'm sure it looks to you like it should be simple to store multiple values in a single field but in fact it is quite a lot of work. There is nothing in Access that will help you because Access conforms to standard database normalization theories which say specifically that it is incorrect to store multiple values in a single field. You have a 1-many relationship. The many-side data should be stored in a separate table.

You can show it "mushed" if you insist but in order to work with it, you'll be much happer if it is stored properly.

There are several posts on this very topic from today and hundreds from other days. The advice is always the same. Storing the data properly will save you a great deal of work in the long run.