I have an unbound combobox with a query as the row source and limit to list = true.
Is there a way to retrieve a "not in list" entry from the combobox.
The idea is to use the new entry to add to the list in the notinlist event so the operator does not need to re-enter the text.
Trouble is me.combobox returns the first entry the query returns, not the current text in the combo.
I've tried .column(0) and .value, both return the first query result.
Edit.
Duhh. I looked at the event and there's the answer, newdata.
Is there a way to retrieve a "not in list" entry from the combobox.
The idea is to use the new entry to add to the list in the notinlist event so the operator does not need to re-enter the text.
Trouble is me.combobox returns the first entry the query returns, not the current text in the combo.
I've tried .column(0) and .value, both return the first query result.
Edit.
Duhh. I looked at the event and there's the answer, newdata.
Last edited: