[AccessD] Field Entry question

Charlotte,
Memo key for new fields is manually entered. When I try to
add a new record as I type in the first character I get the
first error.

Error 1:Field can not be updated.
Error 2: Defines the problem as IncNum can not update.

Neither error returns a number to write code around.

Joe Hecht
jmhecht at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Wednesday, February 08, 2006 11:38 AM
To: Access Developers discussion and problem solving
Subject: Re: [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


Website: http://www.databaseadvisors.com