Re-paint subform (1 Viewer)

[TPugh]

Hi

I have a macro that does some calculations on a sub-form. I'm using it as an invoice. As I enter hours in the Time textbox the macro calculates the dollar amount in the Price textbox, triggered as I change the hours.

The problem is that the results are not up to date. The access help said to use Re-Paint at the end of the macro. When I do this I get an error saying that the form is not open.

Help!
Tom

 

[nagaraj15]

did u try the requery function? in the macro, it may refresh the textbox with the latest result