Hello all,
As the title suggests, I am trying to open a form "frmTaskInfo" containing a specific record (primary key = "TaskID") when double-clicking on the "TaskDesc" field on a subreport "sbrptTodoList". Here is the code I am using:
Code:
Private Sub TaskDesc_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmTaskInfo", _
WhereCondition:="TaskID=" & Me.TaskID
End Sub
When I double-click on the TaskDesc field, I get the error, "Microsoft Access can't find the field 'TaskID' referred to in your expression." I had programmed this with a command button on a subform with success, however I was not able to format the continuous subforms to my liking. This same function should be possible from a subreport, no? I have included an image of my SELECT query for sbrptTodoList in case that is helpful.
Any help will be greatly appreciated!
cardgage