Is it really impossible to control the update of a subfrom vs main form

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

Guest

I have a main form with a subform. The practical example is Order header and detail. My experience is I can control how and when to write the header record to the table but cannot control the subform. What I want to do is to edit the header and detail (the subform may have several lines) and update the two tables at the same time. If I want to undo (cancel) the header update, I want to undo (cancel) detail lines also

Appreciate some suggestion.
 
With bound form/subform, you cannot write all the data at the same time. You
also cannot write independent records using an unbound subform. So your 2
alternatives are to use an ActiveX grid control instead of a subform, or
delete the data in the subform using either code or a cascading delete
relationship.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Jeffrey said:
I have a main form with a subform. The practical example is Order header
Click to expand...
and detail. My experience is I can control how and when to write the header
record to the table but cannot control the subform. What I want to do is
to edit the header and detail (the subform may have several lines) and
update the two tables at the same time. If I want to undo (cancel) the
header update, I want to undo (cancel) detail lines also.
 
Back
Top