Hi,
I have a form which controls purchases.
There are two subforms:
1. Shows the items purchases
2. One field on this which totals the items purchases in 1
What I would like to occur is that as soon as 1 is exited, 2 is updated.
I have placed a save option on exiting 1, but that does not update 2. I could put a refresh button on the main purchases form which does update 2, but I would like this to occur on exit of 2.
Could someone suggest how this could be done and any suggested code would be helpful as I have toyed with refresh & requery without success.
Many thanks.
I have a form which controls purchases.
There are two subforms:
1. Shows the items purchases
2. One field on this which totals the items purchases in 1
What I would like to occur is that as soon as 1 is exited, 2 is updated.
I have placed a save option on exiting 1, but that does not update 2. I could put a refresh button on the main purchases form which does update 2, but I would like this to occur on exit of 2.
Could someone suggest how this could be done and any suggested code would be helpful as I have toyed with refresh & requery without success.
Many thanks.
