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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter main form to records with no related records in subform,maintain updateable recordset 4
Using SQL Query Code in Form Module to Return Record Count 2
SQL Query with subForm?? 1
Ado Recordset updatable in Code but not via Form 3
Curious Reaction to subform SQL statement 11
Combo can't find new record in subform 1
Access Datasheet subform not working for SQL Recordset 1
Record Level Filtering 4

Back
Top