Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2004-04-07
1
Medium Priority
?
834 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 1600 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

609 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