Forms not displaying results of query

[eacollie]

I have a form and subform in the format of a calendar. The form displays the dates for the week, the subform the "happenings" for that week.

I'm having intermittent problems displaying the "happenings" on the correct dates. I can't seem to find a pattern to the problem. I can show the correct information in a query (which replicates the data that should appear on the form based on the same information) so I believe the problem is with the form and not the query.

Any suggestions? I know this is vague, but I'm not sure where to start.

Thanks!

 

[Adam Caramon]

Any suggestions? I know this is vague, but I'm not sure where to start.

Yes, that is very vague. I'd suggest attaching your database, or a trimmed down version of it with all working parts for the form to operate as you expect it to. Then someone can take a look for a better idea of what is going on.

 

[eacollie]

Thanks Adam.

It will take me awhile, but I'll do that as soon as possible.

Thanks again!

 

[eacollie]

OK here it is. Test 2, 3, 4, 5, and 7 display OK on the calendar.
Test 1, 6, and 8 do not.

Thank you so much for any help you can give!

 

[eacollie]

If I create a query using the subform recordsource and add a column in the query for each day of the week (using the control source on the form, ie

=IIf([txtSun] Between [StartDate] And [EndDate],[Event]," ")

), it results in the correct data. However, it is intermittently not displaying the correct data on the form.