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
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