Results 1 to 3 of 3
  1. #1
    sud2017 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    148

    Generate custom REPORT from FORM elements

    Hi Experts,

    I have a cost estimation form which contains fields such as quote no, customer name, and items with cost, markup and price etc. This will be an internal costing form of our company when my database is complete. I want to generate a Quote Summary REPORT from this FORM that includes all the details EXCEPT few sensitive info such as item costs and mark ups in the report. Costs and Prices are in caculated textboxes.



    I have no exprience generating reports yet so I thought to take some opinion before approaching this. I want to generate report from the form that can be provided to customers as a pricing summary.

    Your advise to best approach this will be greatly appreciated. Thank you.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Options:

    1. Save the data to table. Build report based on the table or a query. Open report filtered to specific record(s). This is basic Access functionality.

    2. textboxes on report reference textboxes of open form

    3. print the form
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    sud2017 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    148
    Thank you very much June7. This was so helpful. I went by option no 1 and the report is working perfectly. I used SetTempVar in onlick event of Open Report command button to open report to current QuoteID_PK. Thanks again for your time and help.

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

Similar Threads

  1. Replies: 2
    Last Post: 02-24-2017, 03:40 AM
  2. Button to Generate Report from Form
    By faythe1215 in forum Forms
    Replies: 14
    Last Post: 02-02-2015, 04:22 PM
  3. Replies: 2
    Last Post: 03-06-2012, 07:20 PM
  4. Replies: 3
    Last Post: 11-01-2011, 10:22 AM
  5. Replies: 2
    Last Post: 04-12-2011, 08:33 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