| | |
|
|
|
Is it really impossible to control the update of a subfrom vs main form |
|---|
| message from =?Utf-8?B?SmVmZnJleQ==?= on 15 May 2004 |
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.
|
| =?Utf-8?B?SmVmZnJleQ==?= replied to Albert D. Kallal on 15 May 2004 |
Thanks. I will study it carefully and hope it would work with Access 2002.
|
| Arvin Meyer replied to =?Utf-8?B?SmVmZnJleQ==?= on 15 May 2004 |
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.
|
| =?Utf-8?B?SmVmZnJleQ==?= replied to Arvin Meyer on 15 May 2004 |
What is Active X grid control? Appreciate some info on this. Many thanks.
|
| Arvin Meyer replied to =?Utf-8?B?SmVmZnJleQ==?= on 16 May 2004 |
There are dozens of them out there. Typing "ActiveX grid control" into
google will get almost a thousand hits. I've used T-List from Bennet-Tec.
http://www.bennet-tec.com/btproducts/activex.htm
|
|
Archived message: Is it really impossible to control the update of a subfrom vs main form (MS Access Forms)
