Opening Report from Form - tricky - urgent (1 Viewer)

[Browser]

I am viewing a record in a form, and want to be able to click a button and view a report on that particular record.

The report would usually list all records, but based on the ID of the record on the form, we wish to filter the report to show only that records data.

ANY help greatly appreciated as we're in a bit of a bother.
cheers
dan

 

[Keith P]

try
Dim myCriteria as string
myCriteria = "[Id] = " & me![Id]
docmd.openreport "myReport",,,myCriteria