Need help with click Event

[DXXPublic]

Im very new to MS Access and im working currently on a Task Management Database.

Ok this is the structure im using

Tables:


tbl_Tasks
tbl_Responsible
tbl_Meetings
tbl_updates

Queries:
qry_tasks

Forms:
frm_Summary
frm_tasks_details
frm_updates_subform

Reports:
rpt_Meetings
rpt_Tasks

---------------------------

My main form is the Summary Form (frm_Summary). Inside that form i have the 2 reports rpt_Meetings and rpt_Tasks.

Information of rpt_Meetings is generated from the table tbl_Meetings and the report rpt_tasks is generated by the query qry_tasks.

Visually it looks the way i want. But i want to be able to do the following:

On the rpt_tasks (that is in frm_Summary) i want to be able to click the ID of the tasks (ID_task) and when click to open the frm_tasks_details and go to the task number i clicked

On the report i add an event with this

DoCmd.OpenForm "frm_Tasks", acNormal, "ID_task =" & [Reports]![rpt_Tasks]![ID_Task]

When i do so get an error 2451.

Now if i open the rpt_tasks directly and try it from there it works fine, but not when opening it from the frm_Summary.


Anyone can give me some pointers on what am i doing wrong?


Thanks

[June7]

Can't reference the Reports collection because the report is not open as a report - it is an object contained within a subform/subreport container control. Reference the container control that holds the report.

I always give container control a name different from the object it holds, like ctrTasks. Then code:

& Me.ctrTasks!ID_Task

[DXXPublic]

Thanks a lot.

[orange]

Since you are admittedly new to Access, I'm going to suggest you work through a tutorial that will help you with every database you ever develop. Many who are new to Access jump right in to Access (believing all the marketing). From experience I can assure Access needs to work with a well designed database, and, a well designed database isn't automatic just because you're using Access. A well designed database is based on design concepts and this tutorial will help you, but you must work through it to get the experience.
Good luck.