open row in a report leaked from a specific listbox

[peya02]

I have a form with a listbox where I choose a table row and then I want a button I want to open a report with all fields of that row in question. I have the macro but I do not tell me that this will be in question. As is done in VBA but Access does not like OpenOffice is going to base. Access is as follows:

DoCmd.OpenReport "Orders", acViewPreview, "OrderID IN (" & NumerosPedidos & ")"

NumerosPedidos where is the code of the row I want to see.

Thank you.

[QuazzieEvil]

That is not easily done in Base. There is no Built-in DoCmd feature in OpenOffice.org Basic. You can use the BaseTools extension (experimental). However, the RunCmd.OpenReport function does not to filtering, just opens the report. A suggestion is to base the report on a query. before you open the report modify the query's SQL (COMMAND);
_________________
Free Docs @ http://www.baseprogramming.com/resources.html
Book @ lulu.com http://www.lulu.com/content/2455551

[peya02]

Thank you,

I've been trying to do as what I said but I can not modify the sql query and get to open the report on this consultation.