Finding record of a different form.

  • Thread starter Thread starter Mike Coleman
  • Start date Start date
M

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.
 
I almost forgot the rowsource is set to an stored proceedure

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

Does this make a difference.
 
Back
Top