J
Jack
Hi,
We have an Access application where one views Purchase Order by clicking
through three successive forms, MainForm, ProcessingForm and LookupForm.Each
of the
MainForm and the ProcessingForm are menu forms. However the Lookupform is a
form that consists of four combo boxes for lookups. One chooses the value of
the
combo boxes and clicks View. This opens up the Purchase order corresponding
to the values chosen from the combo boxes. While opening this form it goes
through various routines and outputs the form for viewing.
Now a additional search form has been developed. The search gives a
resultset that is summary of various purchase order. One can choose a
particular row of the resultset. Now I need to come up with a
way to view the Purchase order directly from the search result.
I plan to do this so that I will not have to change any of the code that is
associated with the view of the purchase order. I realize in order to keep
the
code untouched I have to devise a way so that it mimics the process of
opening a purchase order via the mainform, processingform and the lookupform.
In other words, if there is a button in the statusform named
viewpurchaseorder, and if I am in a particular Purchase order number
(actually four numbers) in the resultset, it should
open the purchase order as if it has gone through the three successive forms.
That means Clicking the view button should trigger an event of a click of a
menuitem of the mainform, which in turn should trigger a event of opening a
menu item in the processing form which in turn should trigger an event to
open the lookup form with the values of combo box set from the chosen
purchase order
and trigger opening of the view button.
Is this possible in code? If so, i would appreciate any help/direction on
this. Thanks
We have an Access application where one views Purchase Order by clicking
through three successive forms, MainForm, ProcessingForm and LookupForm.Each
of the
MainForm and the ProcessingForm are menu forms. However the Lookupform is a
form that consists of four combo boxes for lookups. One chooses the value of
the
combo boxes and clicks View. This opens up the Purchase order corresponding
to the values chosen from the combo boxes. While opening this form it goes
through various routines and outputs the form for viewing.
Now a additional search form has been developed. The search gives a
resultset that is summary of various purchase order. One can choose a
particular row of the resultset. Now I need to come up with a
way to view the Purchase order directly from the search result.
I plan to do this so that I will not have to change any of the code that is
associated with the view of the purchase order. I realize in order to keep
the
code untouched I have to devise a way so that it mimics the process of
opening a purchase order via the mainform, processingform and the lookupform.
In other words, if there is a button in the statusform named
viewpurchaseorder, and if I am in a particular Purchase order number
(actually four numbers) in the resultset, it should
open the purchase order as if it has gone through the three successive forms.
That means Clicking the view button should trigger an event of a click of a
menuitem of the mainform, which in turn should trigger a event of opening a
menu item in the processing form which in turn should trigger an event to
open the lookup form with the values of combo box set from the chosen
purchase order
and trigger opening of the view button.
Is this possible in code? If so, i would appreciate any help/direction on
this. Thanks