Posted on 2011-02-19
Last Modified: 2012-05-11
Please reference the attached files used in conjunction with an access data base.   I have two pages "Home1" and "Home2".     The Hyperlink located on "Home1" directs perfectly to "Home2".   I am able to edit and update
correctly on "Home1".    However, when EDIT and Update on "Home2" is used it does update but is updating the
entire data base row leaving blank information for that row deleting previous data.   With the filter applied  to "Home1"  displaying only open items in the status row,  it no longer displays when returning home.  

How can I edit page 2 or "Home2" without impacting the entire data set row after update?  
Question by:BOEING39
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
LVL 41

Accepted Solution

guru_sami earned 500 total points
ID: 34938399
If you just want to update Reason2 and Parts then adjust your UpdateCommand and UpdateParamters on home2 to use only the fields that needs to updated.

UpdateCommand="UPDATE [AOS] SET [Reason1] = ?, [Reason2] = ?, [Parts] =? WHERE [ID] = ?"

<asp:parameter Name="Reason2" Type="String" />
<asp:parameter Name="Parts" Type="String" />
<asp:parameter Name="ID" Type="Int32" />

Open in new window


Author Closing Comment

ID: 34940219
Thx I worked that out with your help.  I ended up using detail view instead on form2 as it was more useful presented that way.  Thank You

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

695 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