Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2016
    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
    Crystal Beach, FL, Florida, USA
    Thanked 40 Times in 39 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