Creating a Windows Wizard Style form (list boxes)

[lemon_balm]

I am currently creating a database to link together a maintenance system and a conditional reporting system and I’ve run into a little problem.

I am trying to create a form for assigning skills to a given contractor (contractor selected via a combo box (cboContractor)) by transferring selected items from a list box on the left (lstAvailable) to a list box on the right (lstselected). (much like any windows wizard would) This is done through the 4 buttons cmdSelect, cmdSelectAll, cmdDeselect, cmdDeselectAll.

Now it has been a long time since I have had to work with VB and I am struggling a little to create the required coding to pass data from one listbox to the other.

For reference:

CboContractor takes information from tblContractor. The data is ContID and ContName and the bound column is 1.
LstAvailable takes information from tblSkills. The data is SkillID, SkillComm and SkillNotes. Bound column is 1
LstSelected will place data into tblcontskills.
Tblcontskills has the fields, tcsID, ContID, SkillID

Can anyone help or does anyone know where I can find some good examples on the net as I have browsed through the search pages here and not really found a great deal that is valid

Thankyou in advance for your help everyone

 

[pono1]

Attached is a sample to re-kindle your VBA knowledge...

Regards,
Tim

 

[lemon_balm]

Cheers TIm

That's excellent Tim

I should be able to work the information from there into a workable scenario.

Many thanks

Jason