<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6249.1">
<TITLE>Printing record set displayed in from in a report</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hello All,</FONT>
<BR><FONT SIZE=2 FACE="Arial">I have had a database given to me that is split into a FE of Access XP and a BE of SQL. There is a form that is bound to a table and presents the record data to the screen through the selected form. The user wants to print the current record set through a report from a button on the form. The form displays the complete record but the report will print about half of the information from the screen. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">The problem I am running into is that when I call the report from the form I get more than just the current record, Access wants to print the entire table. I think I am missing the connection between the SQL record set presented in the form and the Report. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">My starting question is how do I refer to the record set, currently displayed on the form, as I get the report open. The Report is currently bound to the same SQL table the form is bound to. Can you refer to a form's record set in the report property? This selective printing thing is new to me and any direction or helpful hints are greatly appreciated. Thanks! </FONT></P>
<P><FONT SIZE=2 FACE="Arial">Patrick L. Hollermann</FONT>
<BR><FONT SIZE=2 FACE="Arial">Park Industries, Inc.</FONT>
<BR><FONT SIZE=2 FACE="Arial">PO Box 188</FONT>
<BR><FONT SIZE=2 FACE="Arial">St. Cloud M</FONT><FONT SIZE=2 FACE="Arial">N</FONT><FONT SIZE=2 FACE="Arial"> 56302</FONT>
<BR><FONT SIZE=2 FACE="Arial">Phone 320-229-3384</FONT>
</P>
</BODY>
</HTML>