I am trying to use the Allow Value List Edits option and have it display a form to enter new Part Numbers. I typically don't allow this in databases, but the client is adding new part numbers all the time as adding new inventory items.
The issue is that the Value List Edit Form does open up properly when the user types in a new part number, however, the newly-entered part number does not automatically display on the value List Edit Form. I've tried in several ways using VBA but can't seem to get it to work. Any quick way to accomplis this without writing the whole routine using the Not On List property?