>The report doesn't open the table itselt. I inquire on something by selecting the record from a combo box. Then I have a print button on the toolbar. When the report says print next 1 it does the 1st record in the table. When it says print for table.field = THISFORM.cboname.displayvalue I get a blank page to print.
>
>>>I have a print button on a toolbar that I want to print the current record. I have set a report method for the form that says REPORT FORM ... NOCONSOLE NEXT 1 TO PRINT. It prints the first record in the table not the current record. What have I done wrong?
>>>
>>
>>Does the report open the tables itself, or does it use the alias in use in your DE? If it opens tables for itself, you need to get it to position to the corect record; in the second case, you want to scope the report to REST.

Hi Jane:

PMFJI: You may want to be sure the DE of the report has no tables in it that are screwing this up. I think that's what Ed was driving at. Also, if you want only a single page or just for a single value from your lookup field, how about just doing a SQL select into a cursor, make the cursor the active select area and invoke REPORT FORM xxxxx will just print all records in the cursor. Then, of course, re-select your earlier select area and go your merry way...

HTH

Rob