Help Please ???

[shariefoo]

Hi all.. I am tryin to use the following code but it dose not work for some reason. The code is:

Me.RecordsetClone.FindFirst "[age] = '" & Me![txtage] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark

Usually when u write the "." a list appear for you.
It dose when i write "me." then when i select recordserclone and i try putting a "." after it no list appears ???

why is that ??

Help please..

Thanx

 

[mvos]

Try

Dim rst as object
set rst = Me.RecordsetClone
rst.FindFirst "[age] = '" & Me![txtage] & "'"
Me.BookMark = rst.Bookmark
set rst = Nothing

Is age text or numeric? If numeric you can lose the single quotes.