Locating record on a continuous form

[Gary S]

Using code behing a form, how do I reference a specific record number, say number 6, on a continuous form containing 25 records

Thank

Gary S

 

[Mattias Jonsson]

Gary,
You can access that record by using something like:

*** warning: air code ***
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
rst.FindFirst "IDField="&Something
If Not rst.NoMatch Then
MsgBox rst("asdf")
Else
MsgBox "No match"
End If
Set rst = Nothing
*** end code ***

Hope this helps,
Mattias Jonsson

Using code behing a form, how do I reference a specific record number, say

number 6, on a continuous form containing 25 records?

 

[Gary S]

Thanks Mattias, works very well, congratulations on your 'air code'....

One final point, how do I now move the cursor to that record, and is it accessible as a particular record number on that form

Kind regard

Gary S

 

[Mattias Jonsson]

Gary, Glad that worked (unexpectedly) out of the box. You are right, there
is sort of a record number on the form. Try experimenting with the .SelTop
property. It, together with .SelHeight, allows you to select records. If you
just set .SelTop and leave .SelHeight at 1 then you will move focus around
on your continuous form. Hope that helps with the next step / Mattias

Thanks Mattias, works very well, congratulations on your 'air code'.....

One final point, how do I now move the cursor to that record, and is it

accessible as a particular record number on that form?

 

[dan artuso]

Hi,
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
rst.FindFirst "IDField="&Something
If Not rst.NoMatch Then
MsgBox rst("asdf")
Me.Bookmark = rst.Bookmark
Else
MsgBox "No match"
End If
Set rst = Nothing

 

[Gary S]

Thanks again Mattias.

 

[Gary S]

Thanks Dan.