Getting Updated record for calculation

[mbaddar]

Hi,

I posted this in another form. Sorry if you've already read it. I have a Sales Order Form with a subform. The subform has a set of product numbers, descriptions and their prices. A user (presumably a product distributor) can change the prices on the subform. There is a textbox underneath the subform to display the changing calculated price. Each time a user changes the prices, the total calculated price should change (I'm using the dsum method to calculate this price based on the prices values in the table).

The problem is my DSum calculation only calculates based on the prices that were in the table when the form loaded. So, no matter what prices I change when the form is open, the total calculated price only changes after I close the form and load it again.

Hope this question is clear. Any ideas?

Thanks so much for any help.

mbaddar

 

[Rohdem]

sounds like you need to refresh/requery your form Mike Rohde
rohdem@marshallengines.com
"If builders built buildings the way programmers wrote programs, the first woodpecker to come along would destroy civilization!"

 

[mbaddar]

Thanks Rodhem. Yeah, I just figured it out a while ago. I actually needed to requery my subform. When I did this it worked.
Thanks,
mbaddar