Results 1 to 4 of 4
  1. #1
    crimson is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    11

    Results comparison form

    Hi All,


    I have the following issue:
    1. In my database I have one table "inputdata" and a form generated from that table, for data entry and preview
    2. There are 5 queries performing different canculations based on data from "inputdata", and one query "K_Analiza", callecting results of calculations
    3. Based on "K_Analiza" a report is generated to preview results
    4. For dynamic preview of reports for all records I have one form with combo box containing ID and name from "inputdata" and below it I've placed the report mentioned in point 3. When I pick one entry in the combo box the report is automatically updated with the results for that record.

    What I would like to do, is to create a form, which would be able to display max. 4 reports based on "K_Analiza". In that form I would like to have 4 combo boxes and below each combo box I would like to show report based on the choise from that combo box.

    Generally I would like to create a form, which would work symillary as shown on this website: http://www.gsmchoice.com/en/compare/4834/4049/0/0/

    Is it possible? If yes, how to create such form? Any advise is greatly apriceated.
    Please note, that I would like to avoid using VBA.

    Regards

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make a table for the reports:
    CAPTION, RPT
    Report1, rMyRpt1
    Report2, rMyRpt2

    user picks a rpt in the combo , sees col 1, but col 2 is hidden.
    docmd.OpenReport cboRpt,acViewPreview

    another:
    combo box of say ,clients, to open the report for that client:

    docmd.OpenReport cboRpt,acViewPreview,,"[clientid]=" & cboClient

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    To get ranman's idea to work you would need to set the second column as the bound column in your combo or specify cborpt.Column(1)

    Or swop the columns and set the first column as bound
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    crimson is offline Novice
    Windows 7 Access 2013 32bit
    Join Date
    Nov 2010
    Posts
    11
    It took me a bit to respond, sorry.
    Thanks for the help. I've managed to get it to work, however using a bit different approach: I genereted a form from the said query, set it to view only, no editing or adding new records. Multiplied the form 4 times and inserted them into a blank form.
    I know its not the best solution, but it works the way I want, so I'm happy.

    Regards

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

Similar Threads

  1. Replies: 3
    Last Post: 04-07-2017, 12:23 PM
  2. Replies: 9
    Last Post: 06-18-2015, 07:47 AM
  3. Filtered results without comparison operator
    By Steve_Blackman in forum Access
    Replies: 1
    Last Post: 07-01-2014, 09:36 AM
  4. Replies: 6
    Last Post: 05-14-2012, 07:24 AM
  5. Access Min Max Comparison Yielding Incorrect Results
    By MetalCheese in forum Programming
    Replies: 6
    Last Post: 12-06-2011, 04:29 PM

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