Hi Hwa:

I'm not sure I understand the stated problem -- english is my language, and not your primary one. As I understand it, you want to print a certain record or records, by value. If this is correct, you need to either use the "FOR xxxx" id value clause, or better, put your selected records into a cursor table and just print all of it using your report form.

You could try something like this:

PRIVATE old_select && save the current work area...
old_select = SELECT()

SELECT * ;
FROM orders ;
WHERE value_id = (value desired) ;
INTO cursor TempOut

SELECT TempOut && I know, it should be selected already, but old habits die hard...

REPORT FORM PRINTNOW TO PRINT

SELECT (old_select) && restore the original work area...

then go back to your main loop...

Regarding your naming, I try to avoid using VFP/FP reserved words and keywords for memvars, and objects like tables, directories, etc...

Hope this all helps.


ROB