I've got a crosstab query that returns students and there attendance record over a 4 week period. I want to display the data in a form but can not bound the details to the query. I can only bound the ID field. The date fields do not show up when I try to change the control source to each date returned from the query. I can do this if I create a report because I can unbound the 4 date fields and fill them in the Detail Format section. In a form there is no detail format section. The crosstab query returns something like:
Student ID Week1 Week2 Week3 Week4
1 x x x
2 x x x x
3 x x
How would I get that to display in a form?