Results 1 to 2 of 2

Thread: Afterupdate does not work

  1. #1
    Junior Member
    Join Date
    Oct 2012
    Posts
    26
    Rep Power
    0

    Afterupdate does not work

    Hi everyone.

    Currently i'm using a have a calendar made by microsoft for replacement of datepicker. Everything works fine but i'm not able to initialize the afterupdate event.

    I have connected a textbox to the calendar. so everytime i update the calendar the textbox gets the value of the calandar.

    When i click on the textbox the event works fine

    Code:
    Me.txtDatumSelectie = Me.objKalender.Value
    Me.SF_Urenregistratie.Requery
    Me.txtTotaalDag.Requery
    But i cannot set it to afterupdate so i dont have to do anything except clicking on the calendar.

    The code i used for the calendar in the form:

    Code:
    Private WithEvents calendarForm As Form_frmCalendar
    
    Private Sub calendarForm_DateChanged(newDate As Date)
        Me.objKalender = newDate
    End Sub
    
    Private Sub Form_Current()
        On Error Resume Next
        calendarForm.Value = Me.objKalender
    End Sub
    
    Private Sub Form_Open(Cancel As Integer)
        Set calendarForm = Me.CalendarSubForm.Form
    End Sub
    Why does it not work

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Tony, can you post the file along with the datepicker?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 1
    Last Post: 03-07-2013, 11:42 AM
  2. Search form on work sheet
    By Ryan_Bernal in forum Excel Help
    Replies: 5
    Last Post: 01-15-2013, 11:46 AM
  3. INPUT DATA FORM ON WORK SHEET
    By Ryan_Bernal in forum Excel Help
    Replies: 4
    Last Post: 12-30-2012, 05:56 PM
  4. Replies: 4
    Last Post: 08-14-2012, 03:17 AM
  5. work book format
    By Prabhu in forum Excel Help
    Replies: 1
    Last Post: 03-25-2012, 10:33 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
  •