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.
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.
Comment