<html><div style='background-color:'><DIV>
<P>Hmmmm...rings a bell. I think I saw a qdoc on M$KB about a phony error message with this type of an update/insert. Check there.<BR>_d<BR></P></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things are only free to the extent that you don't pay for them".-Don Elliker </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Tesiny, Ed" <EDTESINY@OASAS.STATE.NY.US>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: RE: [AccessD] Field cannot be updated
<DIV></DIV>>Date: Wed, 4 Jun 2003 12:22:03 -0400
<DIV></DIV>>
<DIV></DIV>>Charles,
<DIV></DIV>>The datasource for the form is a query, the change involved adding two
<DIV></DIV>>tables to the design and six fields to the query and the form: 2 names,
<DIV></DIV>>2 phone numbers and 2 extensions. Datasource based on a 1-M
<DIV></DIV>>relationship, cbo is on the '1' side. You select a name
<DIV></DIV>>(RecordedByName)in the cbo and it saves the code number (RecoredByCode)
<DIV></DIV>>for the name to a table on the 'M' side. A2002, app is just on my PC.
<DIV></DIV>>As I said you get the error msg but it displays and saves the correct
<DIV></DIV>>data.
<DIV></DIV>>
<DIV></DIV>>Ed Tesiny
<DIV></DIV>>EdTesiny@oasas.state.ny.us
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: Wortz, Charles [mailto:CWortz@tea.state.tx.us]
<DIV></DIV>>Sent: Wednesday, June 04, 2003 11:59 AM
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: RE: [AccessD] Field cannot be updated
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Ed,
<DIV></DIV>>
<DIV></DIV>>Need a lot more info. Did this 'minor' change to the form have anything
<DIV></DIV>>to do with the datasource for the form? Is the datasource for the form
<DIV></DIV>>based on a 1-M relationship? Is the field that cannot be updated on the
<DIV></DIV>>one side of a 1-M relationship? What does your cbo do besides select a
<DIV></DIV>>value from a table? What value is saved to what table by the cbo? What
<DIV></DIV>>version of Access? Is the app monolithic or split into FE/BE?
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Charles Wortz
<DIV></DIV>>Software Development Division
<DIV></DIV>>Texas Education Agency
<DIV></DIV>>1701 N. Congress Ave
<DIV></DIV>>Austin, TX 78701-1494
<DIV></DIV>>512-463-9493
<DIV></DIV>>CWortz@tea.state.tx.us
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: Tesiny, Ed [mailto:EdTesiny@oasas.state.ny.us]
<DIV></DIV>>Sent: Wednesday 2003 Jun 04 10:50
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: [AccessD] Field cannot be updated
<DIV></DIV>>
<DIV></DIV>>Hi All,
<DIV></DIV>>I have a form that I made minor changes to (no changes to the cbo) and
<DIV></DIV>>now when I go to make a selection in a combo box, I get the message
<DIV></DIV>>"Field cannot be Updated" I click on OK and the correct selection shows
<DIV></DIV>>up in the cbo and the correct value is saved to a table. Tried deleting
<DIV></DIV>>and recreating the cbo and I get the same msg. Nothing fancy, the cbo
<DIV></DIV>>is based on a table with autonumber PK and a text field contains a name.
<DIV></DIV>>Enabled property is set to Yes and Locked is set to No. Any Ideas? Ed
<DIV></DIV>>
<DIV></DIV>>Edward P. Tesiny
<DIV></DIV>>New York State OASAS
<DIV></DIV>>Evaluation and Program Monitoring
<DIV></DIV>>1450 Western Ave.
<DIV></DIV>>Albany, New York 12203-3526
<DIV></DIV>>Phone: (518) 485-7189
<DIV></DIV>>Fax: (518) 485-5769
<DIV></DIV>>EdTesiny@oasas.state.ny.us
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>Add photos to your e-mail with <a href="http://g.msn.com/8HMYENUS/2746??PS=">MSN 8.</a> Get 2 months FREE*.</html>