Solved

MS Access: Disable Auto-Update of Form except by Command Button

Posted on 2004-04-07
1
822 Views
Last Modified: 2012-06-27
Hello,

I have a simple form that displays the contents of a table ( via bound control ).

I also have a command button, caption: Update.

I would like to disable/intercept the Auto-Update feature of the form to ONLY update when the user presses the update button.  I do not want the record updated when the user closes or moves to another record within the form (table).

I have looked for several days for the solution and it is either too simple or seldom requested.

If there is a different approach to accomplish the same thing, then please feel free to suggest.

Thank you,

codeman
0
Comment
Question by:chandlh
[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
1 Comment
 
LVL 17

Accepted Solution

by:
walterecook earned 400 total points
ID: 10775242
Personally for this I typically use an unbound form.  Choose a record from your form and click "edit" and it pops up an edit form for that record only.  From there I use a submit button which processes the changes.

Walt
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

717 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