Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


DataGrid control error

Posted on 2003-03-12
Medium Priority
Last Modified: 2008-03-17
I have two forms displaying  database records using a dataenvironment connection.  Form 1 has a datagrid to select which customer to display on the form 2.  Form 2 has many data aware controls to the same dataenvironment connection.  When a customer name is selected/clicked on the datagrid a button is pressed to display form 2.   The user can show form 1 again to select another customer name.  After selecting several different customers on the form 1 which changes the data displayed on form 2 the following error on the datagrid control displays when closing the form 2:  Cannot update '(expression)'; field not updateable.  

When this error displays the only action that has taken place is to change customers.

What is causing this error and what can I do to prevent it?
Question by:jafre

Accepted Solution

girish_its earned 400 total points
ID: 8118121

    When u come back to Form1 to add more customers UNLOAD the Form2 before showing1. After selecting customers LOAD the Form2 Again.

Remember : 'UNLOAD Form2'  not  'Form2.HIDE'

Hope this works.


Author Comment

ID: 8118290
That seems to have worked. What was happening to cause the error. Also, will this have an effect on machine resources by loading and unloading the form multiple times?  

Expert Comment

ID: 8900243
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
LVL 49

Expert Comment

ID: 9664440
Moderator, my recommended disposition is:

    Accept girish_its's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question