Do Cmd code for after update

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amateur - 17 May 2007 14:25 GMT

I have a main form called “customers”
I have a subform in the “customers” form called "billsopenvalue"
I have a commandbutton on the “customers” form which is opening a pop-up
form with the name “receivedpayment”.
So, if I change the “receivedpayment” Form I would like that my Form
”billsopenvalue” (actually the only field which needs to be updated is the
field “resting”) gets immediately updated.
I have tried to do this with the following command:
DoCmd.Requery "sfrmbillsopenvalue"
but billsopenvalue is a subform from “customers” and not from
“receivedpayments” –
Can someone help me to give me the correct After update code.
Thank you very much in advance
Klaus

Reply to this Message

Maurice - 17 May 2007 18:38 GMT

Try this: forms!customers!billsopenvalue.requery

Signature

Maurice Ausum

> I have a main form called “customers”
> I have a subform in the “customers” form called "billsopenvalue"
[quoted text clipped - 10 lines]
> Thank you very much in advance
> Klaus

Reply to this Message

Amateur - 17 May 2007 19:26 GMT

I tried now in the AfterUpdate Event procedure for the field paymentamount in
the form receivedpayments :

Private Sub Form_AfterUpdate ()
DoCmd.Requery Forms!customers!billsopenvalue
End Sub
and

Private Sub Form_AfterUpdate ()
DoCmd Forms!customers!billsopenvalue.requery
End Sub

and
Private Sub Form_AfterUpdate ()
Forms!customers!billsopenvalue.requery
End Sub

Is not working but I think I have somehow as well to mention the fieldname
which should be updated or not? The field name would be form "customers",
subform "billsopenvalue", fieldname "resting" .

Do you have any other idea?
Thanks
Klaus

> Try this: forms!customers!billsopenvalue.requery
>
[quoted text clipped - 12 lines]
> > Thank you very much in advance
> > Klaus

Reply to this Message