manipulating subform recordset (1 Viewer)

[jfi]

I feel like this should be a simple problem but it's just not working. I have a combo box that picks a record and I want to go to a corresponding record on a subform. Here's how I'm doing it:

(Acess 2000)

Private Sub firstmonthgoto_AfterUpdate()
Dim rst As Recordset
Set rst = Me.[objectives subform 1].Form.RecordsetClone
rst.MoveFirst
rst.FindNext "[month#] = " & Me![firstmonthgoto].Column(1)
Me.[objectives subform 1].Form.Bookmark = rst.Bookmark
End Sub

When it errors it says:
Method or Data Member Not Found

and it highlights the FindNext section.

I also tried changing the recordset declaration to dim...as DAO.Recordset
but then that line is highlighted and the error is "User-defined type not defined"

What am I doing wrong?

-Joshua

 

[jfi]

I changed lines 2 and 3 so that they now say

dim rst as object
set rst=.....Recordset.Clone

And now it works. Many more problems after this, I'm sure you'll be hearing about a few of them.

-Joshua