Hello.
scenario
I have one form that has two subforms.
I have a subform that looks similar to a datasheet, but currently it is in continuous forms format due to better formatting and ability to summarise this form. It has 30+ controls which fill the full width of a form allowed (hoping no more controls need to be added!) within the detail. It has to look similar to a superceded excel worksheet formerly used.
i have a seperate subform to the left of this which is literally just a date. This subform is levelled so that the lines in the above subform correspond to the correct line in the date subform.
both of these forms are bound to input parameter of unbound date fields on a different form.
The purpose of this is so that the user can scroll the horisontal bar on the 'main' subform to check the summary of days data and the date will remain in the same place (If the date was within the main subform, the date would be lost when the user scrolls across to see the information it relates to).
Problem:
Due to the different size and resolution of screens of users, i have had to limit both subforms to about 10 working days. If the user enters a date parameter that exceeds 10 working days I have the following issue. The user will scroll down in the main subform, but the date subform will not move in comparison, therefore the date no longer corresponds to the correct dates data.
question:
1.If i were to put the date back into the main subform, how can i fix/freeze that control so that when the user scrolls right then the date will stay where it was, therefore the date always corresponding to the correct information? Preferrably keeping with the continuous form format but mirroring the 'freeze column' function in excel.
2. If it cant be done, how can i get the date subform to move in sync with the main subform when we scroll down, therefore sorting this issue out?
My boss is favouring the data sheet view, but he's not sure how to fix the column either (yet). The directors are preferring the Continuous form due to formatting etc...
I look forward to hearing from you.
regards
Donna
scenario
I have one form that has two subforms.
I have a subform that looks similar to a datasheet, but currently it is in continuous forms format due to better formatting and ability to summarise this form. It has 30+ controls which fill the full width of a form allowed (hoping no more controls need to be added!) within the detail. It has to look similar to a superceded excel worksheet formerly used.
i have a seperate subform to the left of this which is literally just a date. This subform is levelled so that the lines in the above subform correspond to the correct line in the date subform.
both of these forms are bound to input parameter of unbound date fields on a different form.
The purpose of this is so that the user can scroll the horisontal bar on the 'main' subform to check the summary of days data and the date will remain in the same place (If the date was within the main subform, the date would be lost when the user scrolls across to see the information it relates to).
Problem:
Due to the different size and resolution of screens of users, i have had to limit both subforms to about 10 working days. If the user enters a date parameter that exceeds 10 working days I have the following issue. The user will scroll down in the main subform, but the date subform will not move in comparison, therefore the date no longer corresponds to the correct dates data.
question:
1.If i were to put the date back into the main subform, how can i fix/freeze that control so that when the user scrolls right then the date will stay where it was, therefore the date always corresponding to the correct information? Preferrably keeping with the continuous form format but mirroring the 'freeze column' function in excel.
2. If it cant be done, how can i get the date subform to move in sync with the main subform when we scroll down, therefore sorting this issue out?
My boss is favouring the data sheet view, but he's not sure how to fix the column either (yet). The directors are preferring the Continuous form due to formatting etc...
I look forward to hearing from you.
regards
Donna
