I have a form field that's intended to behave like a combobox without the dropdown list. (If this sounds bizarre to you, please just trust me that it makes sense in the context.) What's the best way to handle additions to the "rowsource"? I can think of three options:
- An Append query that runs every time data is entered in the field, but skips over values that are already in the "rowsource".
- An Append query that runs depending on the results of a Select query that checks whether the value is already in the "rowsource".
- An Append query that runs in response to the data error that occurs when a value isn't in the "rowsource".
There may be nothing to choose between these options, but, on the one hand, option 3 seems likely to me to be the quickest, while, on the other hand, I've seen people frown on using error handling in this kind of way.