Dan Waters
dwaters at usinternet.com
Mon Sep 27 14:43:43 CDT 2004
John, Immediately after you use an error value the first time, its value is then 'erased' by Access. So to pass an error value or use it more than once, you need to create a variable like: GlngErrorNumber = Err.Number GstgErrorDescription = Err.Description Now you can use your variable as many times as you like. I don't remember where I first read this, but I was stumped for a while too. There was a description of why this happens, but that's lost to old memoryland too. HTH, Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Colby, John Sent: Monday, September 27, 2004 2:26 PM To: 'AccessD at DatabaseAdvisors.com' Subject: [AccessD] Err What is the secret to passing the error object into a function. I am calling a function like: Public Function Er(objErr As ErrObject, but when I get inside the function the objErr is a zero and all it's properties are empty. John W. Colby The DIS Database Guy -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com