create report based on data from other form?

Or it could be that Project_ID is not an number field. If that is the case
you need to change the call to

DoCmd.OpenReport "test", acViewPreview, ,
"[project_id]=""" & Me![project_id] & """"

Or alternative using ' instead of "
DoCmd.OpenReport "test",acViewPreview,,
"[project_id]='" & Me![project_id] & "'"

Watch out for the line wrap and that should all be on one line. The
newsreader will make that two lines.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Stefan Hoffmann wrote:
hi Seddon,

On 19.04.2010 12:15, Seddon Acaster wrote:
When button (with above code) is pressed I get following message box:

Enter Parameter Value
Ah, good.

When I manually enter a value then the resulting report is displayed
correctly.

What am I doing wrong?
This means that we have either a typo or reference error. For the typo
check the spelling of the parameter name as displayed in the input box
you're getting. For a reference error take a close look at your reports
data source: has the field a table name prefix in its design view?


mfG
-- stefan --