SubForm editing

[Guest]

I have a Main Frm (Cheque data), and a SubFrm (Allocation of cheque amt to
various accounts).
Works fine with Parent/Child facility BUT if after completing a record in
the SubFrm I return to the MainFrm to alter a control (which is a Parent to a
SubFm control) - the SubFrm closes, saving the records to date.
How can make changes in the open MainFrm and have the change reflect in the
SubFrm data.
I am using Access 2000

 

[Arvin Meyer]

If the subform is a true Access subform, it is a control on the main form
and does not close. The only links between them should be the key and
possibly a main form textbox which reads the total in the subform's footer.
If the main form is reading the subform footer, it will continue to do so
after moving off of the subform.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

I have misled you - the SubForm does not close - but the SubFrm records do.
These subFrm records save and close without reflecting any alterations of
data that I have made in the MainFrm - which I expected, as the alterations
are made to the Parent/Child fields
After the original subFrm records close out - a new record appears in the
SubFrm showing the altered data, ready for new data input.
I have tried Requery inside out and upside down, ad nauseum, but to no avail.

Appreciate any help, but be quick, before they put me in a staightjacket.