Sub-Form query error

R

Ray Mooney

I have developed a query that will run okay standalone, but when I run the
query from within a sub-form the results are bogus. It appears there is some
sort of linkage issue when running the query from within the sub-form. I
used the wizard to create the sub-form with the query.

I'm new to access. Can someone help me with this?

Thanks!!
 
V

Van T. Dinh

Do you use references to Controls on the Form being used as the Subform as
Parameters in your Query?

If you do, you need to refer to these Controls using the full syntax like:

Forms!frmMain!SubformCONTROL.Form!ControlOnSubform
 
J

John Vinson

I have developed a query that will run okay standalone, but when I run the
query from within a sub-form the results are bogus. It appears there is some
sort of linkage issue when running the query from within the sub-form. I
used the wizard to create the sub-form with the query.

I'm new to access. Can someone help me with this?

Thanks!!
Click to expand...

Sure, but you'll need to help us too.

What do you mean by "use the query within a sub-form"?
What do you mean by "bogus"?
What's the Query? Could you post the SQL?

John W. Vinson[MVP]
 
Top