I have a form with a subform. In the subform the selections are based off a combo box and an active X calender as the start date.
If I have some with a start date of 10/3/2003 and 10/6/2003 they both show up in the subform, but when you run the query for the report only one the 10/3/2003 shows up in the report instead of two. The combo box is based off the field of Office Held. So if you select ALREM in combo box and select October 3, 2003 two people are in come back in the subform yet the the second person has a start date of 10/6/2003 and will not show up in the report.
What I am trying to say I how can I get all the people that show up in the sub form to be listed in the report when you preview it?
If I have some with a start date of 10/3/2003 and 10/6/2003 they both show up in the subform, but when you run the query for the report only one the 10/3/2003 shows up in the report instead of two. The combo box is based off the field of Office Held. So if you select ALREM in combo box and select October 3, 2003 two people are in come back in the subform yet the the second person has a start date of 10/6/2003 and will not show up in the report.
What I am trying to say I how can I get all the people that show up in the sub form to be listed in the report when you preview it?