Joe Hecht
jmhecht at earthlink.net
Thu Feb 9 00:52:40 CST 2006
So any way, I go to my friend's house who is teaching me how to write more code and we are trying to figure this out. As we go through the query which is the data source I deleted a couple of test rows that are empty. Now we can't duplicate the error. Joe Hecht jmhecht at earthlink.net 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com