Filtering the data and Assigning check box to individual row in a report in MS Access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Hero1234
    New Member
    • Jul 2015
    • 1

    #1

    Filtering the data and Assigning check box to individual row in a report in MS Access

    I have a SQL database (Only one table) linked to access which has about 40000 records and 15 fields. I want the end user to print Labels form the report generated with 4 fields in it, and the user must be capable of searching the required field in a form. the requirements in systematic way follows:

    1.A form which has two combo boxes which are used to filter the data in the reports and buttons to filter and print.
    2.The report should have check box in every row such that, by checking the box the rerspective row data should appear in the form of labels view for print.
    3.When the user searches/Filter the data in the form the report should be at down such that user can see the result instantly and check the boxes which he wants to print the labels.
    Table name: dbo_v_Stores,-- Report: Rpt_v_Stores, -- Label Report: Labels dbo_v_Stores

    I created a form with two combo boxes and entered the field data in it for search. But i couldn't figure out how can i connect the form to the report and how to assign an individual check boxes in every row for the user to select the data which he want to print in the labels.

    I wish someone could solve the issue (Sorry for my bad English)

    Thank you.
    Last edited by zmbd; Jul 16 '15, 04:56 PM. Reason: [z{Please do not double post. Merged threads}]
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    Your report should call your form:

    If you will read thru an follow the tutorial:
    Use parameters in queries and reports
    it should become clear how to modify your application to do the same.

    :)
    Last edited by zmbd; Jul 16 '15, 05:00 PM.

    Comment

    Working...