[AccessD] Field cannot be updated

Ed:

If you open the query and run it can you add a record to it?  IOW is it
updateable?  This has tripped me up more than once.

Rocky

----- Original Message ----- 
From: "Tesiny, Ed" <EdTesiny at oasas.state.ny.us>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, June 04, 2003 9:22 AM
Subject: RE: [AccessD] Field cannot be updated


> 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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com