I'm having problems getting the combo boxes in my forms to display my multiple value fields properly. In the table they work perfectly, but then when I open them up in the form the text values have been replaced by numbers and many of the values are not there (only those selected in the datasheet view of the table and one blank one are there)
The numbers are the key values of the text values from the table I made to hold them, but I can't seem to figure out how to switch them.
To make things even more complicated, in a summary form that has a few of the table's fields on it along with some other data, the table view is also displaying the numbers while the datasheet is still displaying the correct text BUT if you hit the drop-down you can choose from the text choices. BUT (again) if you choose a text choice, you get an error :


the value you entered isn't valid for this field.

This is a web database so I don't have access to all the properties and controls of the normal access databases.