Access 2007-10 table lookup, multiple entry Help

[GeorgeB]

Hello everyone

I am kinda new to Access (well I used it back in 2002 my last time)

and I am trying to create a simple database

it consist of three tables

one of the tables is used as data lookup to fill the field in another table

my problem is that this should be a multiple value field which is easy, but the problem is I need to create a code,form or anything that gives me the multiple values separated by a comma in a message box for example

Thanks very much

[June7]

The values will display fine in a textbox. Why the message box?

I won't use multi-value fields because they are so difficult to work with in code.

I did a test trying to reference the field in MsgBox and Debug.Print. Both errored.

I think you will have to do a query that parses the values into muliple records and then run code to concatenate them into a single string. Review these

http://office.microsoft.com/en-us/ac...010149297.aspx
http://allenbrowne.com/func-concat.html

[GeorgeB]

Thanks for the useful, links, yeah I wanted the message box just as simple code to see how to extract the data