Ok, so I have a very complex report we use for monthy evaluations. The form uses DLOOKUP to reverence the data into the correct field on the report.

The problem I'm having is when I input the next month, instead of a 2 page report, Access duplicates all the information on the report and gives me 4 (basically 2 of the same thing)

Is there any way to stop this? (I can send an SNP file if needed the database itself is over 100MB so... can't email that! but i can send code)

HELP!

This is normally caused by the query creating a "many-to-many" relationship. This causes records to appear multiple times.

You could try setting the query property for "Unique vales " to yes or "Unique Records" to yes. This may remove the dups depending on what fields are getting returned in your query.

Hope this helps...