Multi-Value Field does not submit selection on "OK"

[gaker10]

I know many are opposed to multi-valued fields, but in this case it works out nicely for my purposes ;P



The title pretty much says it all. I pick a couple things from a table to put into a field in a separate table via multi-value lookup, and when I hit ok, nothing happens. Literally. Tried the enter button, tried a mess of different keyboard mashing, and nothing. Referred to this thread which discussed a similar problem, and it did not help.

https://www.accessforums.net/forms/m...mbo-46494.html

Row Source:
SELECT [Cage Codes].[CageCode], [Cage Codes].[Company], [Cage Codes].[Division] FROM [Cage Codes] ORDER BY [CageCode];

[orange]

see if this helps http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

[gaker10]

Where would I find this code in Access? I built my multi value field straight from GUI and no original code.

[gaker10]

Here is something interesting. I have a split database. I modified already existing fields to be multi value fields in my back end, and the multi value field functionality works fine in the back end. So it's the front end that is acting up.

[gaker10]

So I just did a re-link between my back end and front end, closed the form corresponding to the multi value field table, re-opened it, and now it works :\ Guess it just needed a little manual refresh? Anyway, marking this solved-ish.