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:
Expand|Select|Wrap|Line Numbers
- 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
I also tried DoCmd.GoToRecord acActiveDataObject, , acGoTo, iID
To no avail.
Any suggestions out there?