Hi
Having some problems with docmd.findrecord, getting runtime error 2162, in an adp, sql server back end.
On my main form, I have a continuous view subform giving a list of subrecords within the main record. Double clicking on the subrecord changes the subform to a form that gives more detailed information on that specific subrecord. I've been trying to use docmd.findrecord to pull up the info, but I'm getting nowhere.
Here's my code:
-
-
iID = Me.ID.Value
-
Forms!frmInitiative.CommView.SourceObject = "frmComm"
-
Set ctl = Forms!frmInitiative!CommView.Form!ID
-
DoCmd.GoToControl ctl.Name
-
DoCmd.FindRecord iID, acEntire, , acSearchAll, , acCurrent
The error is coming in on the docmd.findrecord part.
I also tried DoCmd.GoToRecord acActiveDataObject, , acGoTo, iID
To no avail.
Any suggestions out there?