Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011

    Unanswered: Update Control To Current Date

    I have a main form named frm_main and on it I have a command button which opens another form and links criteria. The other forms name is frm_needtocontact. After the form frm_needtocontact updates I want the form frm_main to update the control MyDTE to todays date. How can I do this? Only if the form is updated or changed do I want this to happen.



  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Use this code in the secondary Form (named frm_needtocontact):

    Private Sub Form_BeforeUpdate(Cancel As Integer)
     Forms("frm_main")!MyDTE = Date
    End Sub

    Note that the main Form, frm_Main, must be open at the time, otherwise an Error will be thrown!

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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