Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2016
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2013 - need help transferring before update event in form to its subform version

    Hello folks,

    New member, first post.

    I have created a macro in my access 2013 form before update event to log the last touch user and last touch date if a record is edited and saved. This is done successfully when it is a form.

    When I use that form as a subform, it loses its ability to do this function and I can see no option in creating a before event macro for a subform, and it apparently does not transfer its before update ability to the subform version.

    Any advice on how to fix this?

    Appreciate the help and advice.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    The Before Update event is part of the form itself, and should operate whether the form is opened directly or as a subform. There are no events on a subform control (other than Enter/Exit).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Tags for this Thread

Posting Permissions

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