Multiselect listbox passing to a field

[JordanR]

I'm trying to create a database where a single "Classification" field is populated by selections made in a multiselect listbox and I can't figure out how to do this. Any help people can provide?

Table 1:
Name_ID <pk>
Name
Classification

Table 2:
Classification_ID <pk>
Classification

What I want to happen is click on a button next to the Classification field (text) and a popup form with a multi-select list loads (this part is easy, of course). The user can select as many classifications as they want, click the ok button and each item selected then goes back to the first form and populate in the Classification field (seperated by commas or semi-colons).
This possible?

 

[Pat Hartman]

This is not a good idea. Take a look at this post I made earlier today.
http://www.access-programmers.co.uk/forums/showthread.php?t=80258&highlight=multi-select

 

[JordanR]

Ah, and this is how I got really clever
I decided to go away from the multiselect box and go with a subform with checkboxes.
So now, a user goes to the main form and enters information. They click a button and the subform appears. They click checkboxes to select the classifications they want. When they click the button again, the subform disappears and the classification field is populated with all the classifications they selected (seperated by a semicolon).
So behind the scenes all the data is normalized, but to the user's eye, all the classifications are there in an easy to read, easy to query format.

 

[usr33t]

Multiselect listbox

Hello,

I found JordanR's solution to the problem interesting and believe it may help me with a similar problem. I am very new to access, so if anyone knows exactly (step by step) how JordanR did this, or if anyone would be willing to point me in the direction of a sample database I can examine I would be extremely grateful.

Many thanks
Usr33t