Combobox : Multiple and simultaneous itme selection

[miguelsbpgj]

Hello to all ...

On the example attached, at the end of "frmClientesParticulares" , I can select multiple items at the same time from the
" ProblemaID " ComboBox .

I need to apply this concept to other db I'm developing but, even looking carefully to all properties of the example attached I was not able to reproduce this multiple selecting combobox on any other db .

Could anyone explain to me, all the passes, setp by step and from the beginning, how to implement a simultaneous multiple selection combobox like the one on the attached example ?

Please, if you can, enumerate all procedures separately so I can implement it better .

Note I'm not an Access expert !!!

Lots of thanks in advance,

Miguel Garcia

 

[pbaldy]

I don't see a combo box there. It's a subform: "frmSistemasYProblemasAnteriores". To my knowledge, there's no way to make a combo box multiselect. I'd use a listbox.

 

[miguelsbpgj]

I don't see a combo box there. It's a subform: "frmSistemasYProblemasAnteriores". To my knowledge, there's no way to make a combo box multiselect. I'd use a listbox.

Please, as explained in posted thread, open frmClientesParticulares and scroll it all down . You will see a box named ProblemaID .
Click at the right side of its last item added and you will see if it is a combo or not . You can see also if you can select several items from a combo box or not .

Lots of thanks but, if you do not pay attention to what is posts, please, don't answer them because you will confuse posters with your answers .

Anyway ... Thanks !!!

Miguel

 

[pbaldy]

You're the one confused. You have a combo box within a subform. You are not picking multiple items from one combo box, you have multiple records in a subform.

 

[miguelsbpgj]

ok ok , you have the reason

You're the one confused. You have a combo box within a subform. You are not picking multiple items from one combo box, you have multiple records in a subform.

Sorry, Sorry, Sorry ...
I never see things from this point of view until now !!!
You are right .

I'm only associating several items to the same systemID, doesn't I ?

I'm not an Access expert and although the attached example has been anallyzed several times by me to apply the same thing to another db, I was unable to do it .

In this case this is still what I need for the db I'm developing .
Can you explain in detail and step by step exactly how to do this ?

lots of thanks one more time,

Miguel

 

[pbaldy]

Yes, you would use this to represent a one to many relationship (here one system can have many problems). Build a form bound to the "one" table, and another bound to the "many" table. While in design view of the "one" form, use the subform wizard to add the "many" form as a subform. Make sure to set the field that ties the 2 together (in this case SistemaID).