HI,
Hope someone can help.
I'm trying to deal with a new entry added by the user to a LookupComboBox.
In MS Access we have a flag (LimitToList) and event (NotInList) to deal with this situation.
I know these don't exist, so what I thought I'd do was to get the value entered when the DoEditingDone event fires and see if it is in the underlying table, if not I was going to ask the user if they wanted to add it and if so to bring up a new form to get all the data needed and then add it to the table behind the LookupComboBox and manually store the value in the associated data field of the ComboBox.
However, when the DoEditingDone event fires, the value in .Text is empty, presumably because it has already detected that it is not in the dropdown list.
Can anyone throw any light on what I could try next?
Many thanks
Dave