Not on list - do you want to add?

[hayde]

I have a form which brings up an err message saying "not on list - do you want to add to list?" when you add a new customer name. On popup form I enter the new customer and address, etc. and close the form. I then need to reenter the new customer name on the original form. Is there a way to bypass reentering the name and when you close the popup form it automatically populates the first form with the new customer info?

 

[adalger]

On your popup form, try:

Private Sub Form_Close()
    With Forms("[i]main_form_name_here[/i]")
        .Requery
        .Recordset.FindFirst("[[i]field_containing_name[/i]] ='" & Me.[i]control_containing_name[/i] & "'")
    End With
End Sub()

TMTOWDI - it's not just for Perl any more