I have a form and a subform. I wish to update a combo on the subform for each new record. The current event seems to be extravagant since it seems to fire more that once for each new record. Is there a better way of updating the form each time? Or ccan I use something like a static variable to count the no of times it fires and make sure that it fires only once?