Query issue or form?

[Jeff]

I have a form that shows information in a calendar style format. The form
has 37 subform that query for each day. The problem is that this is very
slow, also it will not work over the network at all. I think the problem is
the fact that it requerys for every subform. Are there any alternate ways
to populate these subforms that are not so memory dependant.

I also have a query that returns every record for the month.
Can I filter in some way from the query?

 

[MGFoster]

Subforms always cause the form to load slower. Having 37 subforms is
bound to REALLY slow down the form load. You might try using a
different strategy to show the info.