[AccessD] Field cannot be updated

Ed,

Need a lot more info.  Did this 'minor' change to the form have anything
to do with the datasource for the form?  Is the datasource for the form
based on a 1-M relationship?  Is the field that cannot be updated on the
one side of a 1-M relationship?  What does your cbo do besides select a
value from a table?  What value is saved to what table by the cbo?  What
version of Access?  Is the app monolithic or split into FE/BE?


Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
-----Original Message-----
From: Tesiny, Ed [mailto:EdTesiny at oasas.state.ny.us] 
Sent: Wednesday 2003 Jun 04 10:50
To: accessd at databaseadvisors.com
Subject: [AccessD] Field cannot be updated

Hi All,
I have a form that I made minor changes to (no changes to the cbo) and
now when I go to make a selection in a combo box, I get the message
"Field cannot be Updated" I click on OK and the correct selection shows
up in the cbo and the correct value is saved to a table.  Tried deleting
and recreating the cbo and I get the same msg.  Nothing fancy, the cbo
is based on a table with autonumber PK and a text field contains a name.
Enabled property is set to Yes and Locked is set to No.
Any Ideas?
Ed

Edward P. Tesiny
New York State OASAS
Evaluation and Program Monitoring
1450 Western Ave.
Albany, New York  12203-3526
Phone:  (518) 485-7189
Fax:  (518) 485-5769
EdTesiny at oasas.state.ny.us