[RESOLVED] How to reset BOF

[Lo-Jack]

Hi all,

I am using VB6 with an ADO connection to a Microsoft 2003 database to enter data. My VB form has 4 navigation buttons(First, Previous, Next, Last).
When i click Last i jump to the last record as expected, however when i hit First it stops at line 221 of the database. I can however hit previous and go back all the way to line 1. But while there if i click First again it puts me back on line 221.


Is there a way to reset the BOF value?

Any Ideas?


I figured it out......had a line deleted between 219 and 221....oops.