Problem with form and report

[Guest]

I have a table with 160 records. I am trying to set up my form so the user
can select a record from a combo box, enter the payroll in a text box field
and submit. Then they can perform the same function several times and each
record will show up on my report with the payroll for each separate record.
I’ve tried the combo box on the form page but when you select one or several
selections, all 160 records are displayed on the reports page.
Would also like a suggestion on how to have it set up for the user to enter
the payroll (automatically rounded to the closest dollar) each time they
select a record. Would also like to show the sum (on the reports page) of all
payroll amounts selected on the forms page. Any comments will be appreciated.

 

[AbhijitDDeveloper]

on the submit button onclick event put a sub which will open a recordsource
and save the payroll in the corresponding table. Now for the selection of
records you can put the value in the text box like (2-40) and do some string
function with left and right and show the records from lower vaslue to higher
value and open the report.