[RESOLVED] Combo Box Error

[Argh two glass eyes]

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:

Private Sub cboPlayerSelect_Click()

      If MyProfileRS.RecordCount > 0 Then

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

      End If

End Sub

Thanks In Advance

[Hack]

You first have to Find the name in the database that corresponds to the selection you made in your combo box.

I don't see you doing anything at all with what has been selected.

[Argh two glass eyes]

ok cheers