[AccessD] Do While Loop Problem

If myds.eof = true can't movenext ?

Perry Harold

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Wednesday, August 24, 2005 4:36 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Do While Loop Problem

The following code generates a no current record error on the do while
line. I thought it should exit the do loop when EOF = false was reached.
Thanks.

 

Do While myds.Fields(2) < myds5.Fields(2) Or myds.EOF = True

            'some lines of code

            myds.MoveNext

 Loop

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com