Solved

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

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now