Results 1 to 3 of 3
  1. #1
    Entellex is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Mar 2015

    How to... have information entered into a text-boxes/drop-downs stay, after adding/updating a record

    After I update a record, I want certain text-boxes/drop-downs to continue to hold the information I entered there for the next record, until I decide to enter something else there again.


  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Use code in control AfterUpdate event to set DefaultValue property.

    Me.ControlName.DefaultValue = Me.ControlName
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Entellex is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Mar 2015
    Sweet. Why didn't I think of that. Thanks!

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

Similar Threads

  1. Drop downs error on clear
    By Ruegen in forum Programming
    Replies: 2
    Last Post: 10-31-2013, 12:40 AM
  2. Replies: 2
    Last Post: 06-22-2012, 01:32 PM
  3. database design: conditional drop-downs?
    By sebeckett in forum Access
    Replies: 5
    Last Post: 09-05-2011, 12:46 PM
  4. Collecting data via email with drop downs
    By tlyons in forum Access
    Replies: 2
    Last Post: 01-19-2011, 10:34 AM
  5. Drop downs and serching in subforms
    By joelwebster in forum Forms
    Replies: 0
    Last Post: 12-13-2009, 03:38 PM

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 - Senior Forums