Form won't close

[thart21]

I cannot figure out on which event to place my DoCmd.Close acForm, "Add Records" code.

I want the form to close upon the opening (via NotInList event) of my NotInList form after carrying over the Employee ID to the this form. I have put it on every event I can think of and, since it is still opened in the background, it comes back up after closing my 2nd form, waiting to go through the Not In List event again, even after the 2nd form has saved the new record and requeried my subform. I'm assuming that, since I need it to carry over the Employee ID, that I don't want to actually "close" the 1st form until the 2nd is opened(???)

Any ideas?????

Thanks,

Toni

 

[ahemr]

Have you tried putting the code to close the form (DoCmd.Close acForm, "Add Records") in the On Open event for the second form?