No, the correct work area is selected, but the report will only execute against the top record in the index order. I've just double checked. I've stepped through this many times and it is always the same. I think that I either missed something that is hidden, or the code is obviously possessed. (Okay, I am kidding about that last part.) :-)
>Most likely the wrong work area is selected when REPORT command is executed.
>>I do not understand why it is that a perfectly functioning set of code is now reporting on only the top record in spite of passing over the correct Order # to the REPORT FORM command, as follows:
lnOrderNumber = Orders.Order_No
REPORT FORM Order PREVIEW FOR Orders.Order_No = lnOrderNumber
>>It seems that the REPORT FORM goes for the TOP record each time, and not the record pointed to by the FOR clause of the command.