Hello again,
I am designing a form for a 3-period rolling forecast. Let's try to explain this right...
I would like the user to select a Period (each period is almost a month) covered by choosing an option from a combo-box. I figure I will then need a tab control with 3 tabs, one for period A, one for period B, and one for period C.
Inside each tab is a SubForm listing product code and quantity.
I want to relate the details in tab 1 to "[period selected]" and those in tab 2 to "[period selected] + 1" and those in tab 3 to "[period selected] + 2".
When period A has passed, and it is now period B - the user should select the new period in the combo, and then 'old period B' becomes 'period A' (and the details are filled in), 'old period C' becomes 'period B' and the final tab contains a blank SubForm with the details for 'period D'.
Any ideas? I have no real idea where to start!
I tried doing it myself but I cant seem to carry forward the period with each tab... Also, when I link the child/master thing it won't let me select the 'period + 1'
TIA
Laocon
I am designing a form for a 3-period rolling forecast. Let's try to explain this right...
I would like the user to select a Period (each period is almost a month) covered by choosing an option from a combo-box. I figure I will then need a tab control with 3 tabs, one for period A, one for period B, and one for period C.
Inside each tab is a SubForm listing product code and quantity.
I want to relate the details in tab 1 to "[period selected]" and those in tab 2 to "[period selected] + 1" and those in tab 3 to "[period selected] + 2".
When period A has passed, and it is now period B - the user should select the new period in the combo, and then 'old period B' becomes 'period A' (and the details are filled in), 'old period C' becomes 'period B' and the final tab contains a blank SubForm with the details for 'period D'.
Any ideas? I have no real idea where to start!
I tried doing it myself but I cant seem to carry forward the period with each tab... Also, when I link the child/master thing it won't let me select the 'period + 1'
TIA
Laocon