I have a table with several fields who's display control is combo-box, source
is value list, and multiple values are allowed.
In one of the fields, when I add a new option to the value list, it
automatically appears in the drop-down list in the form. Not so for the other
field! When I go back and add more values to the list, they do not appear in
the combo box drop-down list in the form. I've been working around it by
manually adding the new options to the value list in the form's properties.
Why does it work for one field and not the other? I can't see anywhere where
the field properties are different.
The database is split, the form is on the front end, if this makes any
difference.
Thanks,
Jey