Tesiny, Ed
EdTesiny at oasas.state.ny.us
Wed Jun 4 11:22:03 CDT 2003
Charles, The datasource for the form is a query, the change involved adding two tables to the design and six fields to the query and the form: 2 names, 2 phone numbers and 2 extensions. Datasource based on a 1-M relationship, cbo is on the '1' side. You select a name (RecordedByName)in the cbo and it saves the code number (RecoredByCode) for the name to a table on the 'M' side. A2002, app is just on my PC. As I said you get the error msg but it displays and saves the correct data. Ed Tesiny EdTesiny at oasas.state.ny.us -----Original Message----- From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] Sent: Wednesday, June 04, 2003 11:59 AM To: accessd at databaseadvisors.com Subject: RE: [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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com