Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

Refreshing Parent Form (Easy - I think)

Hi,
This should be easy and I am sure I have done similar before.
However, I have tried numerous variations and all fail.

Click frmMainBig.
Note the yellow fields on the right.
CHange the Qty from 1 to 2.
This will double the "Line Value" field (correct so far).

However, the "Net Total" lower down is NOT refreshed.
(It IS correct if you exit the form and re-enter.  Underlying calculations are fine)

Question: How do I get this field to Refresh?


EEKey-refresh.zip
0
Patrick O'Dea
Asked:
Patrick O'Dea
3 Solutions
 
dj_alikCommented:
Try to requery the controls
0
 
peter57rCommented:
Adding more detail to the first response..

Use the afterupdate evnet of the quantity field...

Private Sub Qty_AfterUpdate()
Me.Parent.[net total].Requery
End Sub
0
 
dj_alikCommented:
Thanks peter57r
0
 
Rey Obrero (Capricorn1)Commented:

you can try

Private Sub Qty_AfterUpdate()
Me.Parent.recalc
End Sub


the Recalc will immediately updates all the calculated controls in the form
0
 
Patrick O'DeaAuthor Commented:
Thanks all,

It works perfectly now!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now