SQL statement works in Query designer, not in form...

  • Thread starter Thread starter Atlas
  • Start date Start date
A

Atlas

I have a strange beheaviour in a form + subform.

When the form is launched the recordset appears empty and the recordcount is
set to 0.

Copied the SQL select statament that is used in the form, and pasted in the
query designer it works.

Any hint? Apparently there are no filters active on the form........

Access 2003 + adp project + ADO recordset.
 
Hi Atlas

Is there a Link Master/Child Fields pair defined in the properties of the
subform control? This will apply an implicit filter to the subform.
 
Back
Top