Thanks for the suggestion. Tried it and it didn't work. I got the error RunTime error 2585 "This action cant be carried out while processing a form or report event". I think it has something to do with the fact that I have the event tied to a field rather than the form properties, but that is just a SWAG.
Thanks for your help and looking at this problem. I got the desired effect by putting DoCmd.Close in the afterinsert property on the form itself. Works perfectly.... What's that they say about skinning cats??