Hello,
I need to create an unbound Form that needs to be populated in two dimensions.
I have "Tasks" and "People." For each "Person" (across the top), I have a number of "Tasks" (down the side). The number of people and number of tasks is not fixed, but the number of rows and columns displayed will be contingent on selected arrays (containing the appropriate people and tasks). At the intersection of each "Person" and "Task" in the matrix, I will have several unbound text boxes that will be filled.
Is it possible to have a form load with like this? My first thought is using a continuous subform (which would work for the "Tasks") but I am not sure if the continuous form propagates horizontally in addition to vertically.
I think I am asking too much of Access in this case, but it would be a "nice to have."
Thanks in advance!
-R
I need to create an unbound Form that needs to be populated in two dimensions.
I have "Tasks" and "People." For each "Person" (across the top), I have a number of "Tasks" (down the side). The number of people and number of tasks is not fixed, but the number of rows and columns displayed will be contingent on selected arrays (containing the appropriate people and tasks). At the intersection of each "Person" and "Task" in the matrix, I will have several unbound text boxes that will be filled.
Is it possible to have a form load with like this? My first thought is using a continuous subform (which would work for the "Tasks") but I am not sure if the continuous form propagates horizontally in addition to vertically.
I think I am asking too much of Access in this case, but it would be a "nice to have."
Thanks in advance!
-R
