G
Guest
I've seen this question posted a few times in the last year, but never an
answer. Maybe there isn't one! But...here's my scenario...
I am creating a simple banking application for our life skills class.
For new accounts there is a main form to capture account holder info, then a
subform to capture account info, and it has a subform to capture the initial
deposit transaction.
I want the account balance in the account info subform/parent to update when
the deposit amount is entered into the transaction subform.
I use the AfterUpdate event in the transaction subform to update the balance
field in the table, now I need it to show on the screen.
I tried Forms!frmNewAccount!subfrmAccount.Requery but I get that message
about field needing to be saved before you can requery. I tried a couple of
variations on using Dirty but it didn't like that either.
I think I just want to refresh the parent form from the AfterUpdate event of
a field in the child form, but I can't figure out how. Any suggestions?
Thanks much,
Kelly
answer. Maybe there isn't one! But...here's my scenario...
I am creating a simple banking application for our life skills class.
For new accounts there is a main form to capture account holder info, then a
subform to capture account info, and it has a subform to capture the initial
deposit transaction.
I want the account balance in the account info subform/parent to update when
the deposit amount is entered into the transaction subform.
I use the AfterUpdate event in the transaction subform to update the balance
field in the table, now I need it to show on the screen.
I tried Forms!frmNewAccount!subfrmAccount.Requery but I get that message
about field needing to be saved before you can requery. I tried a couple of
variations on using Dirty but it didn't like that either.
I think I just want to refresh the parent form from the AfterUpdate event of
a field in the child form, but I can't figure out how. Any suggestions?
Thanks much,
Kelly