Report on single record

[Wally2k5]

In need of help

I have a form which shows for any one Function the wine that was used, the wine details are displayed in a subform. I have a button which should print preview a report which shows the Function information and the Wine Information for that function only.

At the moment, the report shows information from all Functions. I have a macro which should single it out. The macro is On Click, OpenReport...
...Where Condition "[FunctionID] = " & [Forms]![Functions]![FunctionID]

But this still doesn't work.

Wally

 

[ScottGem]

Is FunctionID a numeric field?

 

[Wally2k5]

FunctionID is a numeric field

 

[ScottGem]

That should work, not sure why it wouldn't.