I want to see the name not the Id

[Lily21]

Hi,



I have a form created from a table, I use a query to filter a list of my field (Multiselect list). When I do new record I see the name of my field, but when I come back to change a record, I see the Id and no more the name. How I can fix that ?


Thank you !

[Micron]

Don't think you'll get the answer you want because I think most of us who help here don't use multi value fields. Their suggestions will probably be the same as mine - get rid of them.

http://www.mendipdatasystems.co.uk/m...lds/4594468763

When it comes to table fields, you might find these helpful as well

The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html

[Welshgasman]

Not the answer the O/P wanted, so crossposted after last reply

https://www.access-programmers.co.uk...the-id.318773/

[June7]

I cannot replicate issue.

Did you Compact & Repair and use Windows Compression?

Could make copy of your db and eliminate objects and data and leave only what is necessary to demonstrate issue.