[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now



Posted on 2011-02-19
Medium Priority
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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

650 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