I have a form that has a multivalue field in it, being shown through a combo box. When I pull the data from a table I can get it to display a persons name but store their ID number in the table, making it more user friendly. When I reopened the form the names would appear in the field instead of the numbers, keeping them hidden. As shown

Being made from a table

How its displayed

However when I pull the same information from a query, even though it has the relevant data it still loads in the ID numbers but when pressing the drop down will show the names as normal.

Being made from a query

How its displayed

Just to show the query is still getting the correct data

I make the combo box the same way and have tried it with other queries in the past that have worked but for some reason the screen acts like there is an issue with the data as shown

I have tried recreating the combo box, linking it with the relevant field it will save to but when I use this particular query it still loads the data back in to the field incorrectly. Could this be to do with the fact that the people who are not free are that time are excluded by the query and this would mean it cannot find their name to display so leave it as ID numbers ?

If so I would need to look at a way of returning all results but not displaying them