Results 1 to 3 of 3
  1. #1
    MTSPEER is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    283

    Filtered subform to table


    Hello, I was wondering if it's possible take the filtered results of a subform and append them to a table?

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    If the dataset for both objects contain the same fields. yes. If they dont have the same fields, than yes. But will require a more structured approach.

  3. #3
    MTSPEER is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    283
    I figured it out with the .RecordsetClone property

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

Similar Threads

  1. Exporting Filtered Data from subform
    By MTSPEER in forum Programming
    Replies: 2
    Last Post: 02-09-2016, 10:57 AM
  2. Can't export data in a filtered subform only
    By mayestom in forum Macros
    Replies: 30
    Last Post: 08-11-2014, 09:23 AM
  3. Replies: 12
    Last Post: 05-30-2013, 02:02 PM
  4. DCount on filtered subform
    By TheShabz in forum Forms
    Replies: 2
    Last Post: 07-13-2011, 02:22 PM
  5. Displaying filtered data in subform
    By crxftw in forum Forms
    Replies: 11
    Last Post: 06-17-2011, 09:59 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