Automating an event procedure for a control on a form that is not created and named yet that is bound to a record source not yet created and named, etc., is probably doable but very tricky. I wish I could help, but I cannot without taking more time than I have to offer.
I've always been fascinated by posts where people describe what you did, i.e. buidling forms and tables from scratch at run-time. Wouldn't it be easier, knowing what the data is for and the business practice, to build the forms and tables ahead of time and have them ready BEFORE data is entered? It would make what you need MUCH easier.
Could you educate me on the advantages of the "on the fly" approach to table and form building?
Michigan Dept. of Environmental Quality, Air Quality Division