Different revision for each sub tab control

  • Thread starter Thread starter Deema via AccessMonster.com
  • Start date Start date
D

Deema via AccessMonster.com

Hi Guys,
I have a database that have 8 tabs....In one of the tabs i have a subform
that have another subform.....in my second subform i would like to have a
couple of tabs for each revision ... if i put the 2nd subform in the 1st
tabs, i get that subform with all the revision in each single tab..since
those revisions are only limited to the 2nd subform..I tried a third subform
instead of doing the tab control but didn't work , since in access you can't
have 3 nested subforms....
Is it really possiblt to create different tabs with different revision for
one ID????
Thanks for any solution you can give...
 
Hi all,
It seems that i wasn't clear in my question, so i'll try to explain it
more....
In my database i have a couple of tabs, in one of them i have 2 nested
subform....in the second subform i have multiple supplier for one ID (the ID
is in the main page of the form), those supplier have multiple revision (ex: -
, A, B, C ...etc)... i created another field that have one Mainrevision for
that set of supplier (ex: revA), since i want to create rev B with a
different list of revision for that particular ID(ex:B,C,D,...)......
I tried to put the second subform in a 3rd subform but access does not
accept 3 nested subforms....so i left out with a tab.....but what i'm missing
is a link between the new revision and each tab for a particular ID(that is
in the 2nd subform)..I want to be able to go to a particular ID and check
revA in one tab of that particular subform and see the different revision
related to revA....as well go to the second tab(revB) and check all the
revision related to the same ID as revA....
Hope that i was more clear this time...
I would really appreciate any help you can give....
 
Back
Top