My Continues form is duplicating records

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi
I have a parent / child subform thing. At the parent
level, you select a first and a second value, then the
child subform shows the recorsd relatinf to those
criteria.
However, for someone reason, the child sub-form shows the
same record twide, doubling up the number of records.
This is not the case in the base tables, so its
definitely happening at form level. The SQL statement
behind the child for has a DISTINCT key word, but still
it persists.

Any ideas?
TIA
Tim
 
Back
Top