Bobby Heid
bheid at appdevgrp.com
Wed Feb 8 14:35:48 CST 2006
Set a breakpoint in your error handler. Then go to the immediate window (ctl-g) and enter ? err.number and press enter. Or you could add the err.number value to your error handler error message like: msgbox "Error: " & err.number & " - " & err.description & " has occurred.",vbokonly+vbexclamation Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Wednesday, February 08, 2006 2:54 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] [SPAM SUSPECT] Field Entry question Bobby, I do not think the error number shows. How can I get it? Joe Hecht jmhecht at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid Sent: Wednesday, February 08, 2006 11:50 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] [SPAM SUSPECT] Field Entry question Just see what the error number(s) are and in your error handler so a "resume next" if the err.number is one of those values. Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Wednesday, February 08, 2006 1:53 PM To: 'Access Developers discussion and problem solving' Subject: [SPAM SUSPECT] [AccessD] Field Entry question Importance: Low I have a subform based on the following sql statement SELECT [20ACCTEXT].MEMO_KEY, [20ACCTEXT].MEMO_LINE, Left([Memo_Key],5) AS IncNum FROM 20ACCTEXT; When I try to enter a new record I get an error saying IncNum (a hidden field used as link to parent records) is an expression and con not be edited. If I manually clear the two errors generated everything continues ok. Is there a way to suppress the two errors. Thanks Joe Hecht jmhecht at earthlink.net -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com