G
GeneDenver
I have a combo box (cboPartNo) that is set up so that if a part number is
entered into it that is not contained in the Row Source, the NotInList event
is fired, which takes the user to another form (UnstockedInventory) for entry
of applicable information for the new part. When the new record is saved in
UnstockedInventory, an append query is generated that creates a base record
in the Inventory table from which the RowSource for cboPartNo is generated.
The code then does a docmd.requery of cboPartNo and the new part number
appears in the dropdown. However, when the user then attempts to exit
cboPartNo, he gets an "Error 3164" and is not allowed to exit the combo box
with the choice of the new part, even though it appears in the dropdown.
What am I doing wrong?
entered into it that is not contained in the Row Source, the NotInList event
is fired, which takes the user to another form (UnstockedInventory) for entry
of applicable information for the new part. When the new record is saved in
UnstockedInventory, an append query is generated that creates a base record
in the Inventory table from which the RowSource for cboPartNo is generated.
The code then does a docmd.requery of cboPartNo and the new part number
appears in the dropdown. However, when the user then attempts to exit
cboPartNo, he gets an "Error 3164" and is not allowed to exit the combo box
with the choice of the new part, even though it appears in the dropdown.
What am I doing wrong?