Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Subreport pass through query

Posted on 1998-11-04
2
Medium Priority
?
313 Views
Last Modified: 2008-02-26
I have a sub report that uses a pass through query as its recordsource-it doesn't work(returns no data and gives the error cannot use a pass through query or crosstab as a subreport recordsource).  What would be an easy fix?
0
Comment
Question by:rvindust
2 Comments
 
LVL 7

Accepted Solution

by:
Victor Spiridonov earned 0 total points
ID: 1967597
You must not have LinkChildField and LinkMasterField set.
0
 

Author Comment

by:rvindust
ID: 1967598
That was to easy, thanks
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question