open report after search

[shirvo]

I have a database that you search for an invoice, I have made a report that opens up an invoice by putting in the id for the data entry and calculates all the prices and so on. I need to have a button on the search form that will open the report with the selected invoice data with out asking what the ID is.

[pbaldy]

How about this technique?

http://www.baldyweb.com/wherecondition.htm

[shirvo]

That would print it and didn't open the report at all. HELP please

[pbaldy]

Look at OpenReport in VBA help and check out the available options for each argument.

[shirvo]

I will explain it all with detail.

I have a form called "search invoices" it is a datagrid form with a search box.

Once the invoice is found and is selected I have a button that I need to have open a report.

The report I have is made with a query that asks what the id is. So the report only shows one invoice at a time to what ever the id was.

At the moment when I open the report it askd "What id?" and I put it in.

when i used "DoCmd.OpenReport "select invoice", acViewPreview, , "ID = " & ID"
it opens the report but still asks me for the id.

[pbaldy]

Generally you would use the wherecondition argument of OpenReport or a criteria in the query, not both. If you already have the query restricting the results to the appropriate record, you don't need the wherecondition. Try

DoCmd.OpenReport "select invoice", acViewPreview