List Box Selections

[MJeanBap]

I created a form that upon entry the data is stored on a table. One of the selections on the form is a listbox. How can I get their multi-selections to show up on a table where the data will be stored? Thank you.

[pbaldy]

One way, presuming your structure is compatible.

http://www.baldyweb.com/MultiselectAppend.htm

[MJeanBap]

That was a little helpful. Using the database you provided, in tblOtherTable, is there a way to have multiple employees shown under empID's (separated by commas) or in separate columns rather than rows?

[pbaldy]

Sure, but it would violate normalization rules:

http://support.microsoft.com/default...b;en-us;210203

[MJeanBap]

I see. Then that isn't the best option for me considering sorting and analyzing is something I'd like to do with the data. I think my best bet is to create a subform.

[MJeanBap]

Would you agree? If so, is there a way to create a list box inside a subform?

[pbaldy]

Sure, a subform is the common way of presenting one-to-many related data. You can have a listbox on any form, whether it's a subform or not.

[MJeanBap]

Ok, thanks! I left the form as is for now as I do not want to violate normalization rules. I tried to attach what I am working on but the file is too large? On my Form, I would like the list box to refesh each time a selection and value is "added" by the user. This way users have the option of making another selection, if need be.

I created a table (tblCancerSites) the data will go into, but I also need it to be associated with the record somehow (maybe by assigning some sort of record number), so I know what record or form it's associated with. Could you walk me through what needs to be done? Thank you.

[pbaldy]

Did you try to compact/repair, then zip?

[MJeanBap]

Hopefully this works.

So upon selection of a cancer site/type and a value, and the user will click "ADD" so data can be added to the tblCancerSites. The user should be able to make another selection if they would like so I'd like to clear the selections so additional can be made once 'add' is clicked. I started on some of the coding but it isn't accurate. The data from this selection is to be entered on tblCancerSites. Just so I know which record it's associated with, I've added 'assigned number' to the table, which is on the form.

Then, the information on suspect cases subform, should not be transferred from one record to another. This info on the subform should be found on tblSuspectCases. Just so I know which record it's associated with, I've added 'assigned number' to the table.

Thank you!

[MJeanBap]

Does anyone have any suggestions on how I could accomplis this? Thanks!