Results 1 to 2 of 2
  1. #1
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141

    Print a Report based on the selection made in the Split Form

    I have created a split form with the following fields: (drop down for all fields and can choose 1 or more )

    Form Name: SplitForm1
    Status
    Entered Date
    Company Name
    Request
    Collection Date
    Closing Date
    Fee


    Staff Name
    Remarks

    I have created Report1 to show the following only:

    Status
    Company
    Request
    Staff Name
    Closing Date
    Remarks

    on the form, There is a button to print the report. There are 50 entries, and I choose Status "PREPARATION" that has 5 records, I want this 5 records only to be printed in the form Report1.

    How can I go about this.

    Thank you for the assistance.

    Trident

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you need an unbound combo box on the form that has all possible STATUS recs.
    If null, the report prints all records,
    if not, the report prints ONLY the records of that status.
    in the ON CLICK code for the button:

    Code:
    sub btnPrint_click()
    dim sFilter
    
    if not IsNull(cboStatus) then sFilter = "[Status]='" & me.cboStatus & "'"
    docmd.OpenReport "myReport",acViewPreview ,,sFilter
    
    end sub

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

Similar Threads

  1. Print report based on the checkbox selection
    By LukeSept in forum Access
    Replies: 4
    Last Post: 10-19-2015, 11:34 PM
  2. Replies: 5
    Last Post: 08-05-2014, 09:13 AM
  3. Replies: 3
    Last Post: 07-03-2013, 10:38 AM
  4. Replies: 3
    Last Post: 03-11-2013, 05:11 PM
  5. Replies: 3
    Last Post: 12-11-2012, 09:12 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