I am new to access, so I will greatly appreciate any help....
I have three forms and three tables
Forms Names are:-
1) frmCommand
2) frmProductRevision
3) frmProduct
Field name for each Tables are:-
1) tblCommand
Field Name: C_UniqueID ----- C_Name ----- PR_UniqueID
2) tblProductRevision
Field Name: PR_UniqueID ----- P_UniqueID ----- PR_RevisionName
3) tblProduct:
Field Name: P_UniqueID ----- P_Name
There are two buttons in frmCommand:-
1) Open Product Revision
2) Open Product
There is one button in frmProductRevision:-
1) Open Product
In order to open frmProduct from frmCommand using a button, following two path can be used ?
a) frmCommand -> frmProductRevision -> frmProduct
--> Here, frmCommand has Button "Open Product Revision" which opens frmProductRevision filtered to that command, and frmProductRevision has button "Open Product" which open frmProduct filtered to that Revision.....
b) frmCommand -> frmProduct
--> HERS IS THE PROBLEM..... I want to open frmProduct by clicking on button "Open Product" on frmCommand directly, which will first filter Revision for that command and then filter Product for that Revision....
Instead of using path a) which opens frmProductRevision inorder to open frmProduct, I want to do all the filtering in frmCommand without opening frmProductRevision.... so that "Open Product" button on frmCommand can directly open frmProduct filtered for that particular command.....
Is there is way to open "frmProduct" from "frmCommand" by clicking Open Product button on "frmCommand" directly ???
Thank you