Re-post...Form/Subform Update question

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

Guest

Hello all, I posted a question to the group last week, but for the life of
me, cannot find it. So, I apologize if this is a re-post, but I am not sure
if it even got posted!

Here is my dilemma. (And I apologize for not adhering to what appears to be
the common naming convention).

I have a form, Frm_Parts, that is fairly intensive. This has to pull data
from 3 other forms(Frm_BOM, Frm_RandD, Frm_Labor), and manipulate this data.
Because the main form, and these other forms are quite full, I have created
buttons on the main form to launch into the other 3 forms. But also because I
need the totals from these other 3 forms, I created a 'hidden' subform on the
main form for each of these forms. My problem is, that, after updating, for
example, Frm_BOM, I close Frm_BOM to return to Frm_Parts, but the total from
Frm_BOM on its subform is not updated unless I press F9. I want this to be
hidden to the user, and not a necessary key press.

I have looked through here, and seen other examples of exactly what I am
trying to achieve, and have tried some solutions, but, apparently am missing
something, because it work for me. I have Access 2000, and Windows 2000.

I am also open to suggestions as to a better way to handle the data
retrieval. Thank you in advance.
 
Back
Top