Combobox form display order

[Duncan]

I have a multiselect combox in a form. When items are selected they appear in a different order that what was selected. When investigating the problem it appears that the on the table the data is sorted based on their ID number (pkID number). This is fine however Access puts any ID number starting with 1 (eg 16) before items that do not (e.g 2, 3, 4 thorough to 9). Any suggestions as to how to keep the display order based on the pkID number order (1 to ......)

[June7]

I haven't used multiselect combo/list boxes (I didn't think combobox could be multiselect) but have seen code that handles them.

Where is it that the selected items are appearing - in a list box? Show the code that performs this manipulation. The PK is an Autonumber field? The code must be converting it to text string and numbers as text won't sort numerically. Somewhere have to convert back to numbers. Can use Val function for that. Or make the values all same length with leading fill characters such a spaces or 0's. (0001, 0016, etc). Format function can do that: Format("16","0000")

[Bob Fitz]

June7

I haven't used multiselect combo/list boxes (I didn't think combobox could be multiselect)

Apparently multi-select combo boxes are now available in A2007 & A2010. This recent thread has some discussion on them in case you're interested.

[June7]

Bob, I think you forgot to post the link. I checked the properties for combo and list boxes. List box shows Multi-Select, combobox does not. So I am curious, even though never have had need for either.

[Bob Fitz]

June7
I think you're right. I'll put it down to tiredness (but I think it's age really). Anyway, the link is: http://www.access-programmers.co.uk/...d.php?t=214460

[June7]

Thanks Bob, mystery solved. I never set Lookup properties in tables so never caught that.