This is a slight continuation of this post here, but this post inst really all that relevant unless you want to see the mess I have tided up...
After a fair bit of trial and error I now think that I have followed normalization and binned the repeating data structures that I had before.
I have now taken the data from 6 or 7 tables and put them into 1.
I have a Main form [Task Details] and a sub form [Task details sub] which has 6 tabs/pages for the details relevant to each task stage. i.e.
tabs/pages as follows
at a glance|Concept|Planning|Render|Warrant|Detailed Planning|Timberframe.
On each tabs I have the same sub-form which as a lookup field [stage]
On form load I want the sub-form to load only entries in the database relevant to each tab.
I thought I would set the on load event for the sub-form in each tab but this I am struggling on how this is done.
Any help that you guys can give, will as always be graciously appreciated.
After a fair bit of trial and error I now think that I have followed normalization and binned the repeating data structures that I had before.
I have now taken the data from 6 or 7 tables and put them into 1.
I have a Main form [Task Details] and a sub form [Task details sub] which has 6 tabs/pages for the details relevant to each task stage. i.e.
tabs/pages as follows
at a glance|Concept|Planning|Render|Warrant|Detailed Planning|Timberframe.
On each tabs I have the same sub-form which as a lookup field [stage]
On form load I want the sub-form to load only entries in the database relevant to each tab.
I thought I would set the on load event for the sub-form in each tab but this I am struggling on how this is done.
Any help that you guys can give, will as always be graciously appreciated.