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

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

    Click image for larger version. 

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

    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
    Ontario, Canada
    Is this not the same issue as here?
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    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: 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
    Kelowna, BC, Canada
    As explained in your previous post, use one report, increment your Control Number then use the expression given by June7 in both threads.

    Vlad Cucinschi
    MS Access Developer

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 - Senior Forums