+ Reply to Thread
Results 1 to 2 of 2

How to evaluate a form after on current event

  1. #1
    Forum Contributor
    Join Date
    03-05-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    301

    How to evaluate a form after on current event

    Hi all.

    I'm having awful trouble with trying to get an evaluation function to fire after a subform on current event.

    I am trying the following

    Please Login or Register  to view this content.
    However, the current event is not picking up the latest information (i.e the query does not appear to run until the End of the current event.)

    But I can't find how to fire this code after the current event is completed. it does not appear that the after update event is useful here either.

    Can someone advise how to get the values of a recordset after the current event is completed?

    Cheers

  2. #2
    Forum Contributor
    Join Date
    03-05-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    301

    Re: How to evaluate a form after on current event

    Nevermind!

    I retried the order of the query, then the evaluation, by putting each in a separate function rather than combined and it seems to have worked correctly.

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to trigger, when date becomes current, a calendar event in outlook?
    By HS_ECSE in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2015, 05:25 PM
  2. [SOLVED] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2014, 08:31 AM
  3. Listbox Click event problem - last and not current clicked data gets filled in form
    By wonderolga in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2014, 09:04 AM
  4. [SOLVED] Open a new form, create new record based on current form / record
    By Cyclops in forum Access Tables & Databases
    Replies: 4
    Last Post: 01-28-2013, 06:36 PM
  5. change event macro to evaluate windows user who initiated the change then send email
    By pmanoloff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2012, 03:31 PM
  6. [SOLVED] trigger event if any data in modified on ONLY the current workshee
    By CRayF in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-23-2005, 05:05 AM
  7. evaluate employees form?
    By razorback in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-22-2005, 06:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1