Combobox list does not match query

[tcox]

I have a combo box with multiple columns, and a query that generates the list for it.
Problem is, for one of the values (from a multi value cell) it is showing the index value for that column, instead of what the query shows should be there.

This is my first time encountering this issue, normally what the query shows, is what the combo box lists.

[ranman256]

check the COL WIDTHS and COL COUNT. make the col width 0 for the index.
if there are 3 columns, index, code, description
then col widths would be:
0;0.5;1

[tcox]

I'm sorry I was unclear in my description of my issue.
Here is a picture to show what I mean.

I need the combobox the reflect the contents of the query.

00 refers to "Double Ot" for sizing. It is the 1st entry in the T_CapsuleSize table.

[tcox]

Bump?

-Tevis

[ssanfu]

Problem is, for one of the values (from a multi value cell)

You have a multi value field (Access does not have cells)? I NEVER use multi value fields - they are a PITA (IMO) to work with.

Having said that, you might want to read
http://www.access-programmers.co.uk/...d.php?t=234481 -----> post # 4
https://support.office.com/en-us/art...e9bebbec31#bm3 --- the section "How to employ a multivalued field in a query"

https://support.office.com/en-us/art...3-b6624e1e323a

[tcox]

I have gotten 3 of my other forms with dropdown boxes to work... however if there is better way, I'm open to it.
I have tooling that works on different size's of capsules. A mix and match of sorts.
The reason I started using a MVF is because I have drop down boxes that list tooling that works for a selected size. All my other forms work, except this one. Its frustrating because the Query works, but the drop down box does not display the query results correctly.