Y
yhengataccessmonster
Hello Everyone,
I have an Order Entry Form composed of a MainForm, a SubForm and 2 Sub-
Subforms. The SubForm is a continuous form. The two Sub-SubForms are children
of a SubForm via a foreign key (which is the Primary Key of a SubForm).
There are some instances when customers revised their order by changing just
the amount of orders or by just removing one item and the rest are the same.
To do this, I would like to keep the initial order (record) and create
another record by duplicating the first order then change the amount (or
remove an item whatever the case maybe) on the new record. The initial order
(record) is being kept to be able to provide history of their orders.
I am aware of A. Browne’s tip (http://allenbrowne.com/ser-57.html) about
duplicating the mainform and its subform. I have also searched this forum
thoroughly to find out similar situation as mentioned but did not find any
one (or maybe I am not searching good enough). I wonder if anyone could shed
light on my issue about duplicating the form down to its Sub-SubForm
considering that the SubForm is a continuous form.
Is my approach above the right one in keeping history of orders?
I am using Access 2000.
Thank you very much for any help that could be extended in solving this
problem.
I have an Order Entry Form composed of a MainForm, a SubForm and 2 Sub-
Subforms. The SubForm is a continuous form. The two Sub-SubForms are children
of a SubForm via a foreign key (which is the Primary Key of a SubForm).
There are some instances when customers revised their order by changing just
the amount of orders or by just removing one item and the rest are the same.
To do this, I would like to keep the initial order (record) and create
another record by duplicating the first order then change the amount (or
remove an item whatever the case maybe) on the new record. The initial order
(record) is being kept to be able to provide history of their orders.
I am aware of A. Browne’s tip (http://allenbrowne.com/ser-57.html) about
duplicating the mainform and its subform. I have also searched this forum
thoroughly to find out similar situation as mentioned but did not find any
one (or maybe I am not searching good enough). I wonder if anyone could shed
light on my issue about duplicating the form down to its Sub-SubForm
considering that the SubForm is a continuous form.
Is my approach above the right one in keeping history of orders?
I am using Access 2000.
Thank you very much for any help that could be extended in solving this
problem.