Results 1 to 4 of 4
  1. #1
    hlbly1969 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2020
    Posts
    7

    How to print different reports from single form based on form input

    Click image for larger version. 

Name:	Ctrl_Rpt_outputs.jpg 
Views:	20 
Size:	77.7 KB 
ID:	44906

    Hello,
    I need to print out 2 different reports depending on the user input from the form.

    In the above screenshot the top is the form. If the user fills out a date in the expiration date field then the label in the middle will print out. If there is no expiration date then user can select the "No Expiration " button on the form and the report on the bottom will print out.

    In either case the Control number on the reports will need to automatically increment by 1 number. This will be a unique number stored in the table.

    Is there an easy solution to accomplish this?

    I have created the form and 2 reports and they work independently. but when I try to use either or I cant get them to work off the form.


    I am guessing there must be an if/then statement somewhere along the lines just can figure where it should be or how to implement it the most effecient way.

    Thanks for any input you can help with.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Is this not the same issue as here?
    https://www.accessforums.net/showthread.php?t=83379
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Don't need two report objects, just calculate value for ExpDate textbox. =Nz(ExpDate, "None")

    But first create record or update Control Number field then open report filtered for that value.
    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.

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    As explained in your previous post, use one report, increment your Control Number then use the expression given by June7 in both threads.
    https://www.accessforums.net/showthread.php?t=83379

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 2
    Last Post: 02-25-2019, 01:15 PM
  2. Replies: 1
    Last Post: 08-30-2018, 05:55 AM
  3. Replies: 1
    Last Post: 10-16-2013, 07:57 PM
  4. Replies: 3
    Last Post: 03-11-2013, 05:11 PM
  5. Print Single Envelope From Form
    By genest11 in forum Forms
    Replies: 2
    Last Post: 03-25-2010, 09:00 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