Subform not updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been using this board for awhile, and have found the answers to many
questions, and for that, I thank you. However, I have hit a brick wall when
it comes to my current situation. I am open to suggestion as well as to a
better way to handle it. (And I apologize if I don't use standardized coding
of forms, etc.).

I have a main form, Frm_Parts. From this form I can hit a button and launch
different forms (Bill of Materials, Labor, & R&D). I don't really have the
desktop space to keep these as sub-forms in the main form. However, I do need
to manipulate the totals on the main form from these other forms, so, in
addition, I have invisible sub-forms of these 3 launchable forms.

The issue I am having is that my totals from the launched forms, after
closing, are not updating the subforms on the main form, until either
closing/opening main form, or pressing F9 when back on main form. I want to
be able to, upon closing the other 3 forms, have the main form totals update
as necessary.

I have tried a multitude of options already displayed on this site, but am
apparently missing something, as none seem to work for me (though do for the
other users). I am also open to suggestions as to a better way to handle this
situation.

Thanks in advance.
 
I have a main form, Frm_Parts. From this form I can hit a button and
launch
different forms (Bill of Materials, Labor, & R&D). I don't really have the
desktop space to keep these as sub-forms in the main form. However, I do
need
to manipulate the totals on the main form from these other forms, so, in
addition, I have invisible sub-forms of these 3 launchable forms.
Click to expand...

Have you looked into using a tabbed page for the different subforms?

Tom Lake
 
John,

Am I correct in my understanding of this situation?... You have hidden
subforms on your main form, and the subforms are bound to the same tabes
as the "launched" forms? And you want the data in the hidden subforms
to reflect changes to the data as entered on the "launched" forms? So,
it seems to me that you need to use a macro or code on the Close event
of the "launched" forms to Requery the applicable subforms.

Having said that, I agree with Tom that using a Tab control on the main
form would be a good approach to look at.

And also, it seems that you are looking at form controls for the
manipulation of data. I think there may be a basic misapprehension
here... I think you could simpify matters by using the data directly
from your tables and queries, rather than jumping around from form to form.
 
Yes, you are correct, in your understanding. I guess it is time to read up on
'tabs'.

john
 
John,

There's not much magical about Tab controls. They do provide an often
convenient solution to managing more than one linked subform on a main
form, and in this sense their usefulness is related to screen "real
estate", rather than data functionality.
 
Back
Top