Multiple Listbox selections problem

Diversion

Dutch Databaser
Local time
Today, 16:25
Joined
Apr 13, 2005
Messages
16
Hi guys new here.

Here's what I'm trying to do:

I made a listbox in which get's it's source from a field in a table named Soft. The field is named Software1.

This field contains a list off software that could be installed on systems.
I allready can select multiple selections from the listbox but what I want to do is the following.

I want to press a button, and after I press the button I want that the selected Software is added to a new listbox which show the Software installed. The software in the second listbox would also be stored inside a Table so that I could print them out in Reports.

To simply explain what I'm trying to do:

SoftwareListbox >> Make multple selections>>Press button>> Adds selected software to InstalledListbox which stores in the softwarelist installed in a Table.

I really hope you guys understand what I'm trying to do.
And sorry for my bad english, should have paid better attention during English class ;)
 
Last edited:
Thank you for replying and the compliment about my English :D

After you explained the 1 to many part it all got a lot more clear to me.
Think I could get a lot further in the development of my database now!

Thnx again!
 
At work again and trying to do what you told me last week.

This is what I did.
Put all the software in the table SOFT using the following structure:

SoftwareID
Software01​

1
Software1​
2
Software2​
3
Software3​
ect.

and put a subform in my form which leads to a form created from the Table SOFT which looks like this:
soft.jpg


it now looks like this when I look at my subform in the original form:
1tomany.jpg


If I now select a checkbox it will select all the checkboxes.So what I now want to do is be able to select the checkboxes one-by-one and make them correspond with the Software that is behind the checkbox so when I click the Button it will place the selected software to the other side.
 
Thnx again for the help!
Does every drop-downlist have it's own TableEntry?
and when I have done this how do I get it to get them in the installed software colum to the right with the click of a button?
 
Implemented your example into my database and it works.
Now need to store what's I put in the new listbox into a Table.
How can I put them in a table?
I kept all the names as in the example you gave me.
 

Attachments

  • form.JPG
    form.JPG
    68.2 KB · Views: 190
Last edited:
As you can guess I only get to work on this for a couple off hours a week.
Tried to add a tblbatchreports and changed all the lstBatchlist to tblbatchlist but that didn't work(why can't it be that easy ;))

I know what your trying to explain to me but I can't get it to work.
Do you have any links to examples showing me how to do this?

Again I really appreciate your help so far.

Thank you,

Diversion
 

Users who are viewing this thread

Back
Top Bottom