Filtering results - simple question

[JimmyG]

I simple question I think...

My database contains a form and a report.
At the moment the report displays the results of every customer in my database. I would like the report to be lauched from a button on my form and filter the results displayed so that it only shows the results of the the current record dislayed only.

I've searched these forums for a similar problem and found a sample database which does what I need but I can't figure out how. (I've attached the database I found so you can see what I mean)

Can anybody help??

 

[Ukraine82]

Jimmy,

The vb code below is only filter the selected record displaying in a form.

DoCmd.OpenReport "ReportName", acViewPreview, , "FieldName = " & FieldName

hth,
Michael

 

[chris_jolly]

Can you only filter a report? I need to filter a query based upon pretty much the same criteria (current record) plus some additional stuff