[AccessD] Field Entry question

You mention two errors but only describe one.  IncNum *is* a calculated
field on the subform, so how are you using it exactly that triggers the
error?  How is memo_key getting populated?  Since you've defined IncNum
as the left 5 characters of Memo_key (which had better have at least 5
chars or you're in trouble), Memo_key has to be populated before you can
work with IncNum.

Charlotte Foust


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Wednesday, February 08, 2006 10:53 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Field Entry question


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