Results 1 to 5 of 5
  1. #1
    crowegreg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    398

    text box

    Within a text box, if data is entered, a procedure exectures within the update event. If no change is made to the text box, how do I get the update event to run?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    You'd have to fire it manually. What exactly are you trying to accomplish?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    crowegreg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    398
    In the update event, it saves the record, then creates a new record, then advances to the new record, then sets the focus to a textbox within the new record. If no update is recognized, the focus advances to the next textbox within the tab order of the original record.

  4. #4
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Hi -

    Do you want that procedure to run whether the textbox was updated or not? If so, you could put it in the On Exit event of the textbox, in which case it would fire when you tabbed out of the text box (or pressed Enter, [usually])

    John

  5. #5
    crowegreg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    398
    That worked. Thanks!!

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

Similar Threads

  1. Replies: 1
    Last Post: 06-04-2012, 04:31 PM
  2. Replies: 1
    Last Post: 05-24-2012, 04:59 AM
  3. Replies: 2
    Last Post: 03-01-2012, 12:21 PM
  4. Replies: 15
    Last Post: 04-01-2011, 11:41 AM
  5. Replies: 1
    Last Post: 11-05-2010, 04:31 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