[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