I have a subform with a list box - value list type for the row source. I added a new option to the row source, using all the same formatting as what's already there to type it in.
In the form view, I see my new option in the drop down. But I can't use it. Clicking on it just prompts a message that says "Select from Dropdown." I can't continue until I click one of the previous items in the list.
I need to add this new item, any ideas?
SOLVED: Ok, I feel dumb. There was a validation rule hidden in a linked table from another database. Had a hard time tracking it down because we have several tables/fields all using similar field names, etc. The new item I had added to the list box was not in the validation rule, hence it wasn't sticking. The "select from dropdown" popup was the validation text. AT LEAST I KNOW NOW.