How to add selected items from a combo box to a listbox on a form (1 Viewer)

[SparkieDEV]

I am looking for a solution to an idea I have.

I have a form and on it has a combo box. That combo box has a list of items related to that form's record. I want to have the ability to select an item on that combo box list and it adds itself to the Listbox on the same form. This should also allow me to add multiple items to the Listbox. I also want additional controls on the Listbox where I can remove selected items from that list at a later date for example.

Background:
I am continuing to build an asset management database. This form is used for creating new incidents on an asset. When creating the new form, I want to select up to multiple "childasset items" to the Listbox.

 

[arnelgp]

you only need to make sure the listbox is bound to a table, so you can add, delete items to it.
you can't add multiple items to the listbox using combobox. you can only select 1 item in a combo.

 

[moke123]

There are a number of alternatives such as multi select listbox or picklists. Depends upon how many childasset items there are, how much available real estate, table set up, etc.

 

[theDBguy]

Hi. I wonder what is the purpose of the Listbox. Will the user use both the Combobox and Listbox? If so, why would you even need a Combobox?

 

[theDBguy]

@SparkieDEV If you would like to reply to a post, please click on the "Reply" button instead of the "Report" button. Thanks!

 

[SparkieDEV]

@SparkieDEV If you would like to reply to a post, please click on the "Reply" button instead of the "Report" button. Thanks!

Sorry about that I think my PC had a funny five minutes as I tried to reply to everyone...

 

[SparkieDEV]

Hi. I wonder what is the purpose of the Listbox. Will the user use both the Combobox and Listbox? If so, why would you even need a Combobox?

I am hoping to answer everyone's questions @moke123 @arnelgp in this reply: The database contains couple hundred assets of which several assets would be related to it. I have three types of forms, Audits, Incidents and Projects. I want to use this idea on the incident and projects forms. The user (me) will select an asset to open a form and within that form I would then select the childassets that are of concern to that incident or project. It is likely that multiple items would need to be selected to "identify" what childasset items that particular form/record is relating to. Thus, I am looking for a way to identify childasset items from a list and record them onto the form perhaps in a listbox.

 

[Galaxiom]

Sounds like it should be a many to many relationship and implemented as a subform.

The table relationships should always be worked out before considering the forms.