Multivalue Combo Boxes in Subforms

[JLDLS]

I have a form that allows multiple values in a lookup column. I use these
values in a subform on another form. The value is displayed as "#Name?".
How do I get the subform to diplay the value instead of this message? Thanks.

 

[John W. Vinson]

I have a form that allows multiple values in a lookup column. I use these
values in a subform on another form. The value is displayed as "#Name?".
How do I get the subform to diplay the value instead of this message? Thanks.

By understanding what underlies Microsoft's misdesigned, misleading so-called
"Lookup Field".

It's another TABLE.

In some arrangements it's a *concealed* table, hidden from view. Multivalue
fields are a case in point.

Lookup fields and multivalue fields do NOTHING which cannot be done with
perfectly normal relational tables... with the advantage that the normal
tables are exposed to view and available for manipulation, unlike the
concealed "multivalue field" tables.