Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    After update handling (Access 2000)

    I want to put one and same function under 2 controls in my subform. The controls are
    called quantity and cartons. Is it posible to build a code that recognizes the after update event of the controls quantity and cartons. In other words, my code must
    recognize the after update events of the control and the cartons.Something of the following order

    If Me![MySubform].[Form].[Quantity].AfterUpdfate = True Then
    Do Something
    Else If Me![MySubform].[Form].[cartons].AfterUpdate = True Then
    Do something
    End If

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: After update handling (Access 2000)

    Why would you put code destined to be used on a subform in the main form?

  3. #3
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: After update handling (Access 2000)

    because it is placed in the module section of the database.But if you disregard that, is it possile at all to use one and the same function in both controls
    placed in the afterupdate event?

    Regards

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: After update handling (Access 2000)

    Perhaps my reply to one of your fellow students in <post#=343554>post 343554</post#> will help.

Posting Permissions

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