<div>
<div class="content wysiwyg-content">
I am writing some code to go through a recordset and I want something that will stop at the last record and disable the next button. &nbsp;When I use: If .eof then disable, it makes the user hit it twice. &nbsp;I am wanting to try to use something on the lines that if the .AbsolutePosition equals the .RecordCount then disable it. &nbsp;However, AbsolutePosition is not returning values it should. &nbsp;It is always -1 or -3, as opposed to which record its on. &nbsp;I am using ADO to a SQL 7.0 server. &nbsp;How can I do it? &nbsp;Code example please.
</div>
</div>


I am writing some code to go through a recordset and I want something that will stop at the last record and disable the next button.  When I use: If .eof then disable, it makes the user hit it twice.  I am wanting to try to use something on the lines that if the .AbsolutePosition equals the .RecordCount then disable it.  However, AbsolutePosition is not returning values it should.  It is always -1 or -3, as opposed to which record its on.  I am using ADO to a SQL 7.0 server.  How can I do it?  Code example please.

AbsolutePosition question

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.