Normal Topic can I Force Update of SubForm in another form? (Read 568 times)
Wilder
Member
*
Offline



Posts: 25
Joined: Jun 11th, 2015
can I Force Update of SubForm in another form?
Aug 7th, 2015 at 2:44pm
Print Post Print Post  
Hi All

Have written an application for Insurance Agent to track Policy Holders and their Policies, and other customer information. 

Screen A has the Policy Holder Info with 3 subforms sub form 1 has the policies held by Policy Holder.
In sub form 1 You can click on the Policy Number and bring up the Policy screen Screen B.  Changes can be made to Screen B.  Screen B has command button to "Update" record, and return to Policy Holder Screen A.

The Information Contained on Screen A Subform 1 does not change (different form I Know),  But the Information on Screen A Subform 1 will overlay changes made in Screen B when you process Screen A. There are 25 fields on Screen B of which 9 are on Screen A Subform 1.  When Screen A is processed  if any of the 9 SubForm fields were changed on on Screen B they get over layed by Subform Data when Screen A is processed.  When I "Update and Return" on Screen B I also need to Refresh Screen A Subform 1 so that the data matches. 

Also note that the subform is a Relational link subform, not a natural link.

I have other forms I can do the same by
----
vTmp = @SelectTreeItem("Search Update Menu!search (F7)")
vTmp = @SelectTreeItem("Search Menu!Search Commands!Retrieve New Results (F10)")
----
but this is a single record result set

Is there a command that will reload Screen A Subform 1 either form Screen A or from Screen B, or a "group of commands"?

Any assistance is greatly appreciated.

Foye

Thanks

  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: can I Force Update of SubForm in another form?
Reply #1 - Aug 10th, 2015 at 5:19pm
Print Post Print Post  
You can either do this by:
A. Using @FormAsDialog for the Policy Screen, then FormFieldValue calls to update the resulting data.
B. Closing the Policy Holder form behind you when you go to the Policy Form, and including a Policy Holder button on the Policy Form that returns to the Policy Holder form while closing the Policy form.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged