-
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
-
Code:
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
-
Thanks BAO
Thanks so very much for Taking the time to help...you're terrific.