I have an access database (db1), an

[DannyTmoov2]

I have an access database (db1), and i'm trying to use a data environment (de1)to view details of a table (table1). I've successfully set up the data environment and can drag and drop the fields onto a dummy form, however I can't seem to view any of the records. In the form I use the following code with the aim to simply load the data and cycle through the records:

Private Sub Command3_Click()
de1.rstable1.Open
End Sub

Private Sub Command1_Click()
de1.rstable1.MoveNext
End Sub

Private Sub Command2_Click()
de1.rstable1.MovePrevious
End Sub

something seems to be working because I can click the next button x amount of times but if I then click the back button x+1 times I get the BOF error indicating that i've gone past the 1st record. However none of the fields are visible and the textboxes remain blank.

Any ideas would be VERY much appreciated as i'm going out of my mind!

Thanks
dan

 

[MakeItSo]

Have you tried a DoCmd.Requery [your textbox] command after your open, movenext and moveprevious commands?
This might solve your problem.

Regards,
Andy

 

[CCLINT]

MakeItSo, This is the VB Database forum and not MS ACCESS forum702