Multi-Select List Box

[CHI - JW]

I have been working on a new access database for the NHS but have come up against a problem.

I have created a list box of options from a table and when i change the properties ion the form to a mulitple selecting box it looks ok.

But when you make the selections then move to the next record then move back they have all been reset.

has anyone got any ideas, would be really appreciated.

Jason

 

[indesisiv]

I also came across this problem whilst doing a database for the NHS ... would love to know if there is an elegant solution.

What i did was created an array of bound hidden check boxes and then made one of them check if the corresponding thing on the list box was highlighted.

Then on current event of the form i looped around the chk boxes and re highlighted the list box.

Hope there is a better way to do it but if not good luck.

Steve