Re: Can I Pass this Filter: ([Lookup_Field1].[Field1]="TYPE1"))) From Form to Report?

I must be missing something.

I have tried the suggestion several ways, and every time I get the
error message:

"Joined Table 'RptStudyInformationDetail' not listed in FROM clause"

Of course RptStudyInformationDetail isn't a table but instead the name
of my report. Is it not working because I am setting the recordsource
of the report on the open event?

I really appreciate the help!

Beth

.

Relevant Pages

  • Re: Getting Rid of "Ghost Field" on Access Report
    ... ghost field was still there. ... this afternoon I printed the original report and noticed that I ... attempt to run MyReport#2 I receive an error message asking for a value ... Can you offer a suggestion as to what might be happening and how to fix ...
    (microsoft.public.access.reports)
  • Re: Need LastName to CAPITALIZE
    ... I typed in your suggestion in the control source for the lastname on ... the report. ... I get an error message. ...
    (microsoft.public.access.reports)
  • set focus to report
    ... I want to move focus from one report ... I get an error message. ... a suggestion of how can move focus from one open report to another? ... M. Wilson ...
    (microsoft.public.access.reports)