populating multi-select items to a text field

[delamerbleu]

I'm new to access. Hope someone can offer some help!

I have created a simple database to better organise some day-to-day office data management. For instance, I have a form (just) to record event attended by staff. The data would then be output as a brief report on overall office activities. Since it's event-oriented, staff attendance is just one complementary information. I went through most of the post re multi-select. I understand that it may not be a good idea to return values from multi-select list boxes into a text field, as it would be problematic for using data-analysis in the future.

In my case, I just need to have a text box, neatly (and easy for user, too) shows who attended. As suggested in one of the posting, I follow the instruction of http://support.microsoft.com/default.aspx?scid=kb;en-us;210203. But it doesn't seem working. I attach my databsae (sorry, it's very simple, as I want to test whether the multi-select work).

Your help would be greatly appr ciate!

Also, what about if I group option button, will it allow multiple return by the way?

delamerbleu

 

[RuralGuy]

Here's a sample db I got from one of these forums. I don't know who gets the credit but maybe it will help you.

 

[delamerbleu]

thanks

Thanks a lot! it works perfectly well!