Add new record

[Ivor Williams]

I've a form with an unbound combo box from which a customer is chosen. Limit
To List is set to Yes, in the NotInList event, I've entered the following:

Private Sub Combo33_NotInList(NewData As String, Response As Integer)
DoCmd.OpenForm "frmNewCustomer", , , , , acDialog
Response = acDataErrAdded
End Sub

The intent is to have the frmNewCustomer form open as a popup, enter new
customer information in this form, then close the form and have the
information in the original form populated with the information just entered
for the new customer.

What is happening is this.
On closing the frmNewCustomer form, I get a message which says:
"The text you entered isn't and item in the list. Select an item from the
list, or enter text that matches one of the listed items."

The new customer shows up in the list, but choosing this customer changes
the value in the unbound combo box only. The other information for this new
record does not display until the form is closed then reopened.

I've had code in the past that functioned properly, but no longer. Can
someone please help.

Thanks,
Ivor