Change Value List When "Other" Value Entered
Let's say I have a checkbox form associated with a field "Fruit" whose value list is populated from the field of another table. In the checkbox properties I have "Allow Entry of Other Values" selected so there is always an "Other" checkbox at the bottom. If someone enters a new value, say "Apple", manually I want that value to be a new record in the "value list" field from the other table so it will be a future option for others. I'd be really grateful if anyone has any ideas. Thanks.