Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    2

    Unanswered: Help getting textboxes to automatically show updated dates based on another textbox

    I'm working on a simple time sheet form. I have text boxes for each day of the week set to autopopulate based on a date entered into a text box called txtWkEnding. For example, if txtWkEnding is set to 10/14/2017, txtSuDate will autofill with 10/08/2017. If the date in txtWkEnding is changed by the user, the text boxes for the week do populate correctly, but I have to actually click in one of them for the dates to appear. I need them to appear as soon as I've updated txtWkEnding. How do I accomplish that?

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    1,101
    Provided Answers: 17
    Easiest way would be to add the following to the text box's AfterUpdate event:
    Code:
    Me.Requery
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •