Results 1 to 2 of 2
  1. #1
    Newby is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Posts
    60

    Looking for an Ok before updating

    I created a form a allow renter lease rates to be updated. This requires entering the RenterID, effective of the rate and the rate. I would like to have something like an okay button that needs to be click before it actually update the table. Any suggestions?



    Thanks

    John

  2. #2
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    There are a couple of options:
    1. You can store and manipulate the data in a Temporary Table and not save it to the "real" Table until the user clicks a button.
      • This option would let you "save" the data between sessions. You could stop partway through a Record and come back to it later.
      • It would require some way to manage the temporary Table, likely by delete all its Records after the data is copied back to the "real" Table.

    2. You can use an Unbound Form to display the data and not save it until the user clicks a button.
      • You wouldn't be able to "save" your work partway through and come back to it later though.
      • No Temporary Table needed, so less upkeep.


Please reply to this thread with any new information or opinions.

Similar Threads

  1. Updating form after updating and closing a popup window
    By Historypaul in forum Programming
    Replies: 2
    Last Post: 04-21-2014, 02:13 AM
  2. Replies: 7
    Last Post: 03-02-2014, 08:47 PM
  3. Updating one box from another
    By Sumo in forum Forms
    Replies: 1
    Last Post: 09-27-2013, 09:42 AM
  4. Updating
    By stefan200593 in forum Access
    Replies: 1
    Last Post: 03-31-2013, 09:37 PM
  5. FE & BE Updating
    By mastromb in forum Access
    Replies: 5
    Last Post: 02-12-2010, 11:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums