Open a form when I click a field in the Report

[Neil]

I created a Report of projects wherein there is a fieldnamed PROJECTID
(PRIMARY KEY) shown in the report. I tried creating a macro that if i double
click the ProjectID, it will open the Project Information Sheet form with the
record number.

However, when i tried it it gave an error message of "THE OBJECT DOESNT
CONTAIN THE AUTOMATION OBJECT 'FORM'"

Please help me on this.

 

[fredg]

I created a Report of projects wherein there is a fieldnamed PROJECTID
(PRIMARY KEY) shown in the report. I tried creating a macro that if i double
click the ProjectID, it will open the Project Information Sheet form with the
record number.

However, when i tried it it gave an error message of "THE OBJECT DOESNT
CONTAIN THE AUTOMATION OBJECT 'FORM'"

Please help me on this.

Sorry, Access reports are passive displayer's of data, not interactive
with the user. You just can't do what you wish to do in a report.