List box transferral

[lemon_balm]

Firstly I'd just like to say thanls to Tim for his help in getting me this far. Your coding for multi-select listboxes was great.

However, once again I am having a few problems getting any further.
The problem now isn't transferring data from one list box to the other but is the fact that my list boxes are required to display multiple columns. I have tried playing with the settings in design view and have also tried adding fields into the GetSQL module but to no avail.

Any help on this would be appreciated as I need to get this part of my database live by the end of Feb. (No pressure huh!!!?!?!?)

Hope you don't mind Tim. I have reposted your code here so that others can see where I'm starting from.

Regards

Jason

 

[RuralGuy]

Maybe the following link will be helpful. Making Sense of List Boxes

 

[lemon_balm]

Interesting reading RuralGuy but not quite what I need.

I appreciate that it probably isn't very good db design to have a list of skills which can be picked and chosen at will. However, I do not know another way of getting the relevant information together.

I am creating a skills list where the user can go into my form and pick and choose the skills which pertain to a given company. i.e. construction, electrical engineering, etc. My list is at over 100 items already and will be increasing dramatically once the bosses get a hold of it.

The whole idea is to eventually be able to search for a company via the skills required for the job but first I need to have the input side in place.

The reason I want to have multiple columns transferred across is due to some of the skills being under sub-headings. i.e. Waste Disposal - Sanitary. Irealise I could probably use a piece of code to concatenate these columns together but I would rather keep them seperate for search purposes.

Oh well, anyway if anyone feels they can aid in the creation of this I would be eternally greatful as I have been going over it for about 4 days and just can't seem to find a solution.

Regards

Jason

 

[RuralGuy]

There are many example of ListBox code on the internet. Maybe Candace can offer some ListBox code you need: Candace Tripp's Downloads

 

[lemon_balm]

hi RG
Sorry I've not had chance to look sooner but I've just had a look on Candace's site and couldn't find anything of any relevance to what I'm trying to do.
I want to pick a company from a combo. Then select the skills which are relevant to them, and finally have all this data stored in a table. I would image that the table only need be CompanyID and SkillID as it will just be there to store the links.
I'm hoping that this will create the final link I need to have my database ready for the clients but I just cannot get it working.

Can anyone help?

Regards

Jason