Humm ..
How is the procedure called in the menu ?
is it something like

_screen.activeform.report()

If so i think addinf one select statment to the form's report method will solve the prob .

But then i dont know what exactly is happening .

Hope this helps

>Yes, if I were writing the report, Hiten, that's the way I'd do it. However, Mike is working with an existing procedure that works in his form, so he may not want to change it.
>
>>Hi Barbara
>>
>>Probably u can give a select statment in the menu code .
>>which will select the appropriate report table.
>>
>>Hope this helps