Navigate in listbox

[TonC]

Hi,
With the guidance from VBAX mentor, I solved the puzzle the db is working now.
Still the option explicit is de-activated.
The code for surfing to first and last record told VBAX mentor was very good. So I worked to show the record in my texkfield.
Here is the code as supplement from VBAX mentor:

  
Me.Id.Value = lstBox.Column(0)
Me.txt.Value = lstBox.Column(1)

Many thanks,
Till next time,
Ton