This question describes a kind of a complicated situation but it would be really helpful if I could do what I am trying to do. I have a form (call it BigForm) which has two subforms, call them Subf1 and Subf2. Subf1 is a tabular form with record selectors. I have a routine inside the
sub Form_Current
property of form Subf1. This routine executes every time the user changes the record which is selected in Subf1.
The routine takes one of the fields of the selected record in subf1 and puts it into a global string variable. Then another routine which is called from sub Form_current uses this string to create records in a table. The info in this table depends on the info in the global string variable set with the value obtained from the selected record in subf1.
The second subform (subf2) gets its data from this table. The thing is, the second subform is not ubpdated when this happens. If I close BigForm and open Subf2 directly I see that it now shows the appropriate data in the table, corresponding to which record was selected in Subf1 inside BigForm. But this isn’t really helpful. What I want is for the info shown in Subf2 to be updated when the user clicks on a different record in Subf1. In other words, when the table from which Subf2 gets its data is changed, I would like the information displayed in Subf2 on Bigform to reflect this fact. Is there some sort of a refresh command?
Any suggestions.