go to record in a subform

[alekm]

Hi,
is it possible to apply that GoToRecord method to subform.
When applied to subform on form I allways get message
subform is not open?!

The syntax I use:
DoCmd.GoToRecord acDataForm, "Forms!SomeForm![SomeSubform].Form", acGoTo, 4

The messagge I get:
the object 'Forms!SomeForm![SomeSubform].Form' isn't open.

thanx


alek_mil

 

[Allen Browne]

More or FindFirst in the RecordsetClone of the subform instead.

Example:
Dim rs As DAO.Recordset
With Me.[SomeSubform].Form
Set rs = .RecordsetClone
rs.FindFirst "City = ""Springfield"""
If rs.NoMatch Then
MsgBox "Not found"
Else
.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End With

Note that the record has to be in the subform in order to find it.