Jim Dettman
jimdettman at earthlink.net
Mon Jul 7 11:20:46 CDT 2003
Steve, Might be helpful if you did a cut and paste of the full function. I use that technique all the time and have not had a problem. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steven W. Erbach Sent: Monday, July 07, 2003 11:26 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2K: On error goto next Jim, I'm sorry, I didn't write down accurately what the code says. It already DOES say On Error RESUME Next, not On Error Goto Next. That was my fault when I wrote the original message. When I commented out the rstLookup.Close line I left in the On Error Resume Next followed directly by Exit Function. This isn't any big problem but it sure seems funky. Regards, Steve Erbach Scientific Marketing Neenah, WI "Nothing so needs reforming as other people's habits." - Mark Twain _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com