Results 1 to 2 of 2
  1. #1
    schulzy175 is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Posts
    98

    Keep subform from re-running query when exporting?


    I have a form with the functionality of running queries and exporting them. When I have a query loaded into the subform and choose to export, it then re-runs the query. I haven't found an answer with google yet so I finally decided to ask here. How can I keep the export option from re-running the query when exporting?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Since nobody has answered, I'll venture that you can't. I could be wrong, but I think the export process would need to run the query to export it.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 11-09-2016, 01:45 PM
  2. Exporting Filtered Data from subform
    By MTSPEER in forum Programming
    Replies: 2
    Last Post: 02-09-2016, 10:57 AM
  3. Running Total in Subform
    By Scorpio11 in forum Forms
    Replies: 19
    Last Post: 07-03-2010, 05:44 PM
  4. Replies: 0
    Last Post: 06-21-2009, 01:29 PM
  5. Exporting main table AND subform
    By jenny28 in forum Import/Export Data
    Replies: 0
    Last Post: 05-10-2007, 11:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums