Sometimes Records don't appear in a continuos subform

[Dave the Wave]

I'm experiencing an intermittant problem with a form that I haven't been
able to figure out. I'm hoping someone can give me some directions to
search for the cause/s.

I have a subform -which is displayed as a continuous form- on a main form.
On the subform I have some summary equations in the footer. The summary
equations always display the correct counts and totals as I change the
criteria for the data displayed. The problem is that the records aren't
always there.

Part of the criteria is the month. The first time I view May's data, I may
see 8 records which confer with the summary calculations. I go to June,
then come back to May and now only 3 records are displayed. (The summary
information still indicates that there are 8 records!)

Any ideas?

Regards,
Dave the Wave

 

[Rob Oldfield]

How do you control which records display in the subform?

 

[Dave the Wave]

I have an SQL statement in the subform's module. It retrieves the
criteria in the main form (such as the month and year) and is triggered
every time there is a change in the criteria.

 

[Rob Oldfield]

Your best plan is going to be to add a breakpoint into your code. When the
display goes wrong, check both that SQL and also the filter options on the
subform.