Finding record of a different form.

[Mike Coleman]

I have a form that calls a second form and passes an ID to that form. the
second form allows you to add items to a table that is displayed as a subform
on the main form. I have form.requery and refreshes the data but I would like
to move the cursur back to the record I was just working with. here is the
code I have so far.

Form_frmRLSummary.Requery
Form_frmRLSummary.Recordset.FindFirst TemplateActivityID
DoCmd.Close acForm, Me.Name
end sub

I am getting this error.
"Object doesn't support this property or method"

Help Please.

 

[Mike Coleman]

I almost forgot the rowsource is set to an stored proceedure

Me.RecordSource = "dbo.spRAMGetTemplateActivities"
Me.RecordSourceQualifier = "dbo"

Does this make a difference.