Hi…
I have a form with a field(called Emp_ID). Now, if I enter value in the field & then press F9, I want a computed subform (named Comp_Sf) to be loaded in the same form. What formula should I use for that? Somebody help me out plz…
Subject: Computed Subform after Refresh!
Subforms only compute when the form is loaded. You would need to close the form and re-open it in order to load a new subform.
Subject: RE: Computed Subform after Refresh!
pls i think u can try hide when condition on subform …if that paticular field value is not blank than only showing …may it helps u out…this is suggetion let’s try …i havn’t inplimented yet…
Subject: RE: Computed Subform after Refresh!
Subject: RE: Computed Subform after Refresh!
Thanks for all your response…I think I need to modify according to my requirements…This is what I need…A form with field(Emp_ID) & a computed subform with editable & computed fields(inactivated)…
On entering Emp_ID & pressing F9, the subform should ve computed values and editable fields should be activated…
How to do this Refresh part…
Subject: RE: Computed Subform after Refresh!
You haven’t explained WHY you need a computed subform. We have to assume you want different things to show based upon values found when looking up the employee ID? Why can’t this be handled via a normal hide when formula?
Subject: RE: Computed Subform after Refresh!
Hi Scindia,
I am little confused,Please correct me if i am wrong. As you mentioned based on the Emp_ID you want to load computed subform. If it is the case then put a default value to Emp_ID. Once subform is loaded you cannot reload the subform after changing the field value through refresh. Please see the HELP you can understand. I had faced similar problem.
Note: Subform formulas cannot be refreshed while the document is open.
Cheers,
RAJ