<div>
change your declarations to something like this (form level)<br />
<br />
Dim withEvents RS1 as adodb.recordset<br />
<br />
then you can access all events connected to recordset object. and MoveComplete event is available with recordset object only not with Connection. and MoveComplete fires after moving the record.<br />
<br />
MSDN says <br />
<br />
The WillMove method is called before a pending operation changes the current position in the Recordset. The MoveComplete method is called after the current position in the Recordset changes.<br />
<br />
<br />

</div>


change your declarations to something like this (form level)

Dim withEvents RS1 as adodb.recordset

then you can access all events connected to recordset object. and MoveComplete event is available with recordset object only not with Connection. and MoveComplete fires after moving the record.

MSDN says

The WillMove method is called before a pending operation changes the current position in the Recordset. The MoveComplete method is called after the current position in the Recordset changes.




<div>
Cheers for the help! Only another 255 probs to fix!!<br />

</div>


Cheers for the help! Only another 255 probs to fix!!


<div>
u welcome<br />
<br />
Shahzad
</div>


<div>
<div class="content wysiwyg-content">
I was wondering if anyone could tell me how to solve this problem.<br />
&nbsp;<br />
for my college project, for which I am Using VB6, I have set up a few ADO connections from code (i.e. not by selecting the icon in the toolbar).<br />
&nbsp;<br />
How do I access their events to write code in them particuarly the 'moveComplete' event.<br />
Also am I right in assuming this event executes after record navigation?<br />
&nbsp;<br />
Thanks<br />
&nbsp;<br />
Michael
</div>
</div>


I was wondering if anyone could tell me how to solve this problem.
 
for my college project, for which I am Using VB6, I have set up a few ADO connections from code (i.e. not by selecting the icon in the toolbar).
 
How do I access their events to write code in them particuarly the 'moveComplete' event.
Also am I right in assuming this event executes after record navigation?
 
Thanks
 
Michael

ADO Events ('MoveComplete')

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.