Looping through Combo Box to Print Reports

Originally Posted by apank

I have a report that opens based on the where the office code on the form matches the office code on the report. that works fine.

I have written code that sets the combo box value opens the report (acnormal), then closes report, then sets the combo box value again, opens the report and then close the report.....on and on.

The combo box grows monthly and instead of having to keep updated the code with new office codes, I would like the database to loop through each value of the combo box, print the repot, and then go on to the next one.

Here is the code I am using.

Dim val As Variant
For Each val In Me.ctrlBranchCode

DoCmd.OpenReport "rptBranchProductionWeekMtdYtd", acNormal, , "[Branch Code] = Forms!frmWeeklyMonthlyReporting!ctrlBranchCode"
DoCmd.Close acReport, "rptBranchProductionWeekMtdYtd"

I am gettting an error that says "Object does not support this property or method".

Any help would be greatly appreciated.

A

Originally Posted by ADezii

Here is code that will allow you to return the data in the 'Bound' Column of a Combo Box for each specified Row:

Originally Posted by apank

The procedure you described worked but I cannot get it to update the combo box, then print the report based on the combo, then close the report and print the next one. I am sure the answer is close but I can't seem to find it.

As always your help is much appreciated.

A

Originally Posted by ADezii

1. How are you Updating the Combo Box?
2. At what specific point are you Updating the Combo Box?

Originally Posted by apank

The combo box has a list. I would like the procedure to go through the list, choose each office code listed and print the report(The report prints based WHERE office code = the combo box). I can do it if I hard code the office codes in the procedure and do a set value, but would like it to loop through the combo box instead. That way if new offices are added the report will print automatically.

Thanks

Originally Posted by apank

The series of events should go as follows.
1) Have the report print based on the first branch code in the combo box
2) Close the report
3) Change the branch code in the combo box to the next branch code
4) Print the Report
5) Repeat until the report has been printed for all the branch codes listed.

Originally Posted by apank

Thank you very much for this Adezzi. Worked great.