How to populate these columns? Dorian 11/24/2008 3:13:01 PM I have a form bound to my table and a subform for a related table. The main form contains two calculated controls TotalPaid and BalanceDue. These controls are unbound and are calculated based on the contents of the subform and other controls on the main form. I'd like the contents of these two controls to go into hidden bound controls to populate columns in the main table. My question is what event to do this in. The control source for the calculated controls is set in the Current Event. Would the BeforeUpdate event be the one? Yes, I know its not correct to have calculated values in my table but that is the way it was designed and I cannot change it. Thanks.

Re: How to populate these columns? Rick Brandt <rickbrandt2[ at ]hotmail.com> 11/24/2008 3:25:16 PM On Mon, 24 Nov 2008 07:13:01 -0800, Dorian wrote: [Quoted Text] > I have a form bound to my table and a subform for a related table. The > main form contains two calculated controls TotalPaid and BalanceDue. > These controls are unbound and are calculated based on the contents of > the subform and other controls on the main form. I'd like the contents > of these two controls to go into hidden bound controls to populate > columns in the main table. My question is what event to do this in. The > control source for the calculated controls is set in the Current Event. > Would the BeforeUpdate event be the one? > Yes, I know its not correct to have calculated values in my table but > that is the way it was designed and I cannot change it. Thanks. BeforeUpdate is the correct event. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com