sample program that views the records

Question

Hi guys... I'm trying to make a sample program that views the records from the database like the output above. I am using visual basic 6.0 and Access... With DataControl, I'd like to view the next records of the specific ID Number, by clicking on the Next button. My problem with the code below is the records with other ID Number are appearing...

Private Sub cmdNext_Click()
    With Me.dtaInfo.Recordset
        .MoveNext

        Me.txtCash.Text = .Fields("Cash")
        Me.txtAddress.Text = .Fields("Country")
    End With
End Sub

Private Sub cmdShow_Click()
    With Me.dtaInfo.Recordset
        .Index = "idxIDNumber"
        .Seek "=", Me.txtIDNumber.Text

        Me.txtCash.Text = .Fields("Cash")
        Me.txtAddress.Text = .Fields("Country")
    End With
End Sub

Here's my records

Answer 1

Since you are using the data control you need only bind your text boxes to it.

Right click on each of your text box controls and select "Properties". On the DataSource property set it to your data control. I.e. Data1.

Next, set the DataField property on the text box control. I.e. Cash

When you click forward/back on the data control the text box controls will be updated automatically.

If you really want to take control of the record set navigation for view / update, etc I would recommend switching to use ADO instead of DAO and using your own navigation controls instead of the data control.