Hi All!

Been gone awhile!
I have a mainform - treatment
I have a subform - payment history
payment history is a continuous form

I keep the starting balance and balance due on the mainform

I want to update the balance due after I have entered an amount in the payment history subform - without leaving the subform.

Can anyone help!

Thanks,

Dartcoach

kevin

dartcoach

__________________
dartcoach

Hi,

   Without knowing where you are getting the data on your main form, can't you requery the control on the main form when the pertinent field on the sub form loses focus?



mmcdonal

The main form gets it's data from a table.

The sub form connects based on ID's.
Once I've entered a payment amount - I need to total all payments on the subform, then update the balance due on the main form. I've tried to refresh, requery, just about anything, but it won't refresh until I close the mainform and reopen it.

Thanks for your help.

dartcoach
Kevin

dartcoach

Well, as a quick kludge, you can put code on the lost focus event of the pertinent field to grab the current main form id, then close the main form and reopen it using the current main form id to get the right record.

Someone here will come up with something more elegant shortly I am sure.



mmcdonal

Hey All!
Got it to work!
Basically, all I did was after they enter a payment amount, I use the current record number, then make the subform invisible, then go to the first record, then loop thru adding the amounts until the end. Then I reposition at the correct record and then make the subform visible again. This cause a blink, but it's better than watching the loop thru the form records.

MMCDonal, thanks for your help! Also, if anyone has a better idea, I'll be glad to hear it!

Thanks again!

Dartcoach
Kevin

dartcoach

If you want to stop the blink (which I assume is the subform closing), you could

DoCmd.Echo False

before your code hides the subform, and

DoCmd.Echo True

after you code unhides the subform.

Thanks Randall,

I added the code you suggested. I still get the blink. Being an old mainframe cobol programmer, the blink doesn't bother me too much, even though I would like to get rid of it.

Thanks for your help!

Dartcoach
Kevin

dartcoach