Getting records from a database from on form to another form

[gilsygirl]

Hi Good guys

I am a newbie in VB 6.0. I want to retrieve records from a database. I want to use three fields from the database as a key to retrieve a record and post this record details to a second form.

This what i have for the time being:

Public Sub cmdCheckRest_Click()
 
Dim Key_Fld As String
Dim Exam_Sr As String
Dim Exam_Yr As String
Dim Cand_No As String
Dim cbosch As String
Dim May_June As String
Dim Nov_Dec As String
Dim i As Integer
 
If rs.RecordCount = o Then Exit Sub
 
rs.MoveFirst
 
For i = 1 To rs.RecordCount ' Read all the records from database
Exam_Sr = rs("Exam Series")
Exam_Yr = rs("Exam Year")
cbosch = rs("Cent No")
Cand_No = rs("Index No")
Cand_Name = rs("Cand Name")
Sex = rs("Sex")
 
 
'Exam Serie validation
 
If Exam_Sr = "" Then
        MsgBox "Please supply the Exam Series to search for candidate result", vbOKOnly, "Cannot Find Result"
     Else
  Exam_Sr.SetFocus
     ElseIf Exam_Yr.Text = "" Then
        MsgBox "You have not entered the Exam_Yr.", vbOKOnly
   End If
 
  Key_Fld = (Exam_Sr & Exam_Yr & Cand_No)
' (this is what i want to use as a key from the database)
 
 rs.MoveNext ' read next record
Next i
 
    ' Show a modal form named frmcandResult.
 
     frmCandResult.Key_Fld1.Caption = Exam_Serie
     frmCandResult.Show vbModal, Me 
' (This is where want to send the results of the search)

Thank you very much for your help.

[Ack Programming]

I Would declare my key_fld as Public and on the form_load Event Let The Information be set to the key_fld1.caption Property

[gilsygirl]

I Would declare my key_fld as Public and on the form_load Event Let The Information be set to the key_fld1.caption Property

Thanks for the reply. My problem is combining the fields

Code :vb

Exam_Sr
Exam_Yr
Cent_No
Cand_No

together to form a search key to retrieve records from the database.

Thanks