Data Environment????

[ausmoran]

I have created a Master/Detail form using the data environment in which I have created a Parent/Child data environment command object. I would like to be able to navigate using command buttons (next record, last record, edit record, add record, etc) but I am not sure how to accomplish this. Can someone offer a suggestion on how to add these buttons for navigation.

Thanks in advance!

Austin

[TheBao]

Dim rs As ADODB.Recordset

Sub MoveFirst()
    rs.MoveFirst
End Sub

Sub MoveLast()
    rs.MoveLast
End Sub

Sub MoveNext()
    rs.MoveNext
    If rs.EOF Then
        rs.MoveLast
    End If
End Sub

Sub MovePrev()
    rs.MovePrevious
    If rs.BOF Then
        rs.MoveFirst
    End If
End Sub

Sub AddNew()
    'good to open a new form and add value to text box then
    'save to record set
    rs.AddNew 'add your field and value here
End Sub

Regards,
TheBao

[ausmoran]

Thanks so very much for Taking the time to help...you're terrific.