Open Filtered Form by Double Clicking Subform

[mkallover]

Hi all, I've got a main form containing a subform in datasheet view. I've got one of the fields set up so that when it is double-clicked, the following code runs:

Private Sub TaskID_DblClick(Cancel As Integer)

DoCmd.OpenForm "frmAddTask", acNormal, "[TaskID] = " & Me!TaskID

End Sub

TaskID is just a autonumber field to ID each individual task record. When the form opens, it always displays the first record in the DB instead of the TaskID of the record I double-clicked on.

Any thoughts on what's up with this? I'd appreciate it.

 

[kjv1611]

There might be a cleaner way, but this might work:

Private Sub TaskID_DblClick(Cancel As Integer)

DoCmd.OpenForm "frmAddTask", acNormal, "[TaskID] = " & Me!TaskID
[highlight]Forms!frmAddTask.TaskID.Value= Forms!MainForm.TaskID[/highlight]

End Sub

Of course, that's just taking a stab at it, but without testing it out myself..

--

"If to err is human, then I must be some kind of human!" -Me

 

[kjv1611]

Oh, and before the line I put in, you might have to set focus to that control first:

Forms!frmAddTask.TaskID.SetFocus

--

"If to err is human, then I must be some kind of human!" -Me

 

[mkallover]

Thanks for the response but that doesn't work either. That might work if the original form wasn't in datasheet mode.

 

[mkallover]

Anyone else have a suggestion for this? No matter what I try I can't seem to get it quite right.

 

[mkallover]

Stupid stupid. Pay attention to your commas.

DoCmd.OpenForm "frmAddTask", acNormal, "[TaskID] = " & Me!TaskID

Should be:

DoCmd.OpenForm "frmAddTask", acNormal,, "[TaskID] = " & Me!TaskID

*bangs head on desk*

 

[kjv1611]

Yeah, duh to me, too. I should've seen that when I looked!

Oh well



--

"If to err is human, then I must be some kind of human!" -Me