Doug Murphy
doug at murphyscreativity.com
Mon Jul 7 11:24:31 CDT 2003
Steve, Check to see if you have break on all errors checked in tool, options. I have spent quite a bit of time chasing that one a couple of times. Doug -----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 8: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