Multi value field display on a form or sub-form

[lana]

Hi there,
Can anyone help me regarding the multi-value field?
I have a multi-value field and the selection is OK. Now I need to show the data stored in that field in a text box or a sub-form.
Example: stored data is "David,Smith,Lara" I can see it in the table or in a query but I can not use that query in a subform or lookup the field data as shown.
Any help will be appreciated.
Cheers

 

[moke123]

Here's an article on MVF's and why you should not use them.

Multivalued Fields - Mendip Data Systems

Database applications for businesses, schools and individuals

www.mendipdatasystems.co.uk

Although MVFs can seem an attractive idea for new users, most experienced developers avoid them completely.

However you create them, what you see in the MVF is masking the fact that the records are actually stored as normalised data in a deep hidden system table with a very long name that starts with 'f_' followed by a long string then ends in '_MVF' or whatever your MVF field is called.
It is this separation between what you see and what is actually stored that means MVFs can be extremely difficult to work with.

 

[arnelgp]

you Create a Query and output the .Value part of that field in your query.
use the query as recordsource of your subform.

 

[lana]

Thank you for the replies.
I tried the .value part but it shows the IDs, not the names like (David,Smith,Lara).

Is it possible to show the multi-selected data as it appears in the query (David,Smith,Lara), on a form or I am wasting my time?
Thanks again.

 

[arnelgp]

you need to Join the Lookup table to your Query.

 

[arnelgp]

there is a demo here.
see if you can get something.

 

[lana]

Thanks again.

 

[arnelgp]

ok, goodluck.

 

[isladogs]

Did you read my article about MVFs that was linked in post #2?
Whilst I really don't recommend their use, the article does give you the answer to your question.

 

[lana]

Yes I did. I agree with you completely. it's nonsense.
Thanks

 

[isladogs]

Yes I did. I agree with you completely. it's nonsense.
Thanks

Hopefully you're referring to MVFs being nonsense and not my article

 

[lana]

I meant the MVF is nonsense. Your article helps a lot of people like me.
Cheers

 

[isladogs]