?
Solved

DataGrid control error

Posted on 2003-03-12
5
Medium Priority
?
241 Views
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?
0
Comment
Question by:jafre
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 

Accepted Solution

by:
girish_its earned 400 total points
ID: 8118121
hi,

    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.

BYE.
0
 

Author Comment

by:jafre
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?  
0
 

Expert Comment

by:CleanupPing
ID: 8900243
jafre:
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?
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 9664440
Moderator, my recommended disposition is:

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

DanRollins -- EE database cleanup volunteer
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses

752 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