Jump to specific record on opening

[RichStone]

My database records the reference of the last record opened in a field on the main menu. When the records are selected from the main menu again I would like the record with that reference to open first. I tried setting a filter but I then can't move to other records. What is the best method to do this?

 

[arnelgp]

use the Load event of your form to go to that record:

Private Sub Form_Load()
Dim rs As Dao.RecordSet
If Trim(Forms!MainMenuForm!yourReference & "") <> "" Then
set rs = Me.RecordsetClone
with rs
.FindFirst "[PKField] = " & Forms!MainMenuForm!yourReference
If Not .NoMatch Then Me.BookMark = rs.BookMark
.Close
end with
end if
set rs=nothing
End Sub

 

[RichStone]

Thanks for the reply.

I have copied the code into the Load event and changed the references to those in my database but now I'm getting a compile error that says User defined type not defined and the code is paused on the Dim instruction. Any ideas?

 

[bentheimmigrant]

I copied it in directly, and the "Dao" did not auto-capitalise. Try re-typing it, as it should be "DAO".

 

[RichStone]

Issue solved. I used some completely different code I managed to find in another thread.

Thanks for everyone's help anyway!

 

[ddcessex]

Issue solved. I used some completely different code I managed to find in another thread.

Well, we're all in suspense!

We're all interested in successful solutions so what was yours?