Solved

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

Posted on 2004-04-07
1
816 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
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

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

791 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