Results 1 to 6 of 6
  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727

    pass thru qry

    Hi all, using access 2003 front end sql server 2008 back end. When opening a form with a subform based on a pass thru query, I am getting the following error:



    You can't use a pass-through query or a non-fixed-column crosstab query as a record source for a subform or subreport

    I am using the pass thru because subforms based on regular access query is slow since upsizing to sql server and thought pass thru would be faster. I've search the internet but haven't come accross any solutions. Wondering if anyone has a solution that I may try to get this running.
    Thanks

  2. #2
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727
    Sorry; I posted in another forum and was answered. Thanks for your time.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Would you care to share your solution with the readers of *this* forum?

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Posting the answer here, as Allan suggested, is considered to be proper forum etiquette. Posters coming here in the future, searching for an answer to a similar question, can then benefit from your experience! And you have then added to the forum!

    Linq ;0)>

  5. #5
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727
    The Pass Through
    doesn't work in that situation because of the way the LinkMaster/LinkChildFields
    are processed in a subform or subreport as the main form record changes.

    Instead, remove the LinkFields Properties
    and change the RecordSource of the subform with the OnCurrent Event of the main
    form.

    If you don't want linked tables
    then use a dynamic query or a Stored Procedure with parameters. I found the best
    performance using ADODB commands to return a recordset from a parameterised
    Stored Procedure. Set the subform's recordset property to the returned
    recordset.

    Thank you

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Thanks for sharing SlimJen!

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

Similar Threads

  1. Shift By Pass
    By pkstormy in forum Code Repository
    Replies: 4
    Last Post: 03-18-2012, 05:51 PM
  2. pass value from one form to another
    By ManC in forum Forms
    Replies: 7
    Last Post: 11-25-2011, 09:59 AM
  3. Pass-Through Query or ADO, is there a way?
    By Amber_1977 in forum Queries
    Replies: 3
    Last Post: 11-10-2010, 08:56 AM
  4. Pass Value to Form
    By JohnBoy in forum Programming
    Replies: 5
    Last Post: 06-06-2010, 11:26 AM
  5. how to pass pk to subform
    By ahmed.gomaa in forum Forms
    Replies: 9
    Last Post: 03-21-2010, 10:03 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