I have spent a few days searching the forum to find some code that will allow me to open a databse field into a combo box. I find the code i am looking for and set it up in my program and it works as far as loading the values i want from the databse into the combo box.

The problem is that when i go to select a name from the list i want it to display the rest of this persons details in label on the form but it doesn't it just crashes the error being a run time error 3021, and says that there is no current record.

The section of code that it is not liking is shown below bearing in mind that i have alreday open the recordset in a different section:

Code:
Private Sub cboPlayerSelect_Click()

      If MyProfileRS.RecordCount > 0 Then

           lblSecond.Caption = MyProfileRS("SecondName")
           lblAtempts.Caption = MyProfileRS("Atempts")

      End If

End Sub

Thanks In Advance