[AccessD] Form stopped working

Do you have a backup of the FE?  Sometimes when things suddenly go weird
like this, I have gotten a quick fix by looking at the backup FE.

Debbie

-----Original Message-----
From: JWColby [mailto:jwcolby at colbyconsulting.com] 
Sent: Tuesday, February 06, 2007 12:31 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Form stopped working


I have a bound form that does initial data entry for claims received.  The
form has been working for several years, suddenly it doesn't.  A virtually
identical form still does.
 
The claim table is broken into pieces.  There is a main tblClaim where info
common to all claims is entered.  There are three other tables which are 1
to 1 with tblClaim.  There is a tblClaimLTD, tblClaimSTD and tblClaimWP.
Each of these three tables have one and only one record in them for each
record in tblClaim, but tblClaim will only have a record for STD type
claims, tblLTD will only have records for LTD type claims and WP will only
have records for WP type claims.
 
In order to enter the data I created three different data input forms, one
for STD, LTD and WP.  Each looks similar except that the data out in the
"claim type specific" table will be displayed on their respective input
forms, i.e. the frmLTD form will show data from tblClaim and tblClaimLTD,
frmSTD will show data from tblClaim and tblClaimSTD etc.
 
In order to create the record out in the claim type specific table, I use
code in the form's BeforeInsert event like the following:
 
    Me!CLST_ID = Me!Rec_ID

That line is supposed to place the PK just generated by the autonumber in
tblClaim into the PKID field of tblClaimSTD.  The same code runs in frmLTD
except that the control is bound to the PKID in tblClaimLTD.
 
The three forms have worked for several years.  Suddenly the STD form fails
with an error "the control cannot be updated" on the above line.
 
I have decompiled / compiled / compacted / repaired the FE and the BE.  I
have created a new form and imported all of the controls and code from the
failing form.  I have created a new BE and imported all of the tables into
the new BE.  All of these things have failed to fix the problem.  The LTD
form still works, the STD form still fails.  I have examined the two form's
properties, toggling back and forth between them side by side, no
differences.  I have likewise examined the individual text box's properties
side by side, no differences.  I have examined properties of the PK field of
the two child tables, no differences.  I have looked for different indexes
on the two table's PKs, no differences.
 
I have run out of things to try, and this still doesn't work.  
 
Anything come to mind out in the brain trust?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject
to the Attorney-Client Privilege, (2) an attorney work product, or (3)
strictly confidential. If you are not the intended recipient of this
message, you may not disclose, print, copy or disseminate this information.
If you have received this in error, please reply and notify the sender
(only) and delete the message. Unauthorized interception of this e-mail is a
violation of federal criminal law. 
This communication does not reflect an intention by the sender or the
sender's client or principal to conduct a transaction or make any agreement
by electronic means.  Nothing contained in this message or in any attachment
shall satisfy the requirements for a writing, and nothing contained herein
shall constitute a contract or electronic signature under the Electronic
Signatures in Global and National Commerce Act, any version of the Uniform
Electronic Transactions Act or any other statute governing electronic
transactions.