refreash sub form

[Ken Ivins]

I have a subform sfrmPayment on the form frmCustomer. After I update the
paAmt field I like the field txbBalDue field on sub form sfrmBalDue (query
qryNet) to refresh with the new balance.

I assume I refresh or require but do not seem to get the rest right. Do I do
it on the subform or the query? I just keep getting errors.

Thanks for your help.
Ken

 

[pete]

-----Original Message-----
I have a subform sfrmPayment on the form frmCustomer. After I update the
paAmt field I like the field txbBalDue field on sub form sfrmBalDue (query
qryNet) to refresh with the new balance.

I assume I refresh or require but do not seem to get the rest right. Do I do
it on the subform or the query? I just keep getting errors.

Thanks for your help.
Ken

i have had similar problems when updating a field in the

main form. Until i either go to the next record and return
to the desired record or exit and then return to the
record, the new data is not saved and the subform does not
reflect the change. Maybe a button to refresh data on the
subform would help but the data in the main form would
have to be already saved. i would like to know an easier
way also - hope you find one.

 

[Ken Ivins]

Wayne,

That is an interesting way to do that. At first it did not work but I added
a line at the beginning to set focus on another field on my first form then
saved and it worked great. Thanks. You helped at least two of us.

Ken