Not In List then fill in a form

[naungsai]

Dear Friends

If it is not in list in a "Customer" combo field, I would like to add details of that particular customer in a different form.

I found many Not in List examples. But I did not find to do so.

Thanks in advance

 

[namliam]

1) Create the form you want to have populated
2) Use Docmd.Openform in you on not in list event to open the form, make sure to make it modal and Dialog
3) Refresh your combo upon closure of the form.

Good luck!