Creating Access reports with combo boxes?? HELP

[JP2275]

So, I've successfully (with help from tek-tips) managed to create a parameter query to select a list of employees from a table. I created an unbound combo box with 'OK' and 'cancel' buttons under Forms; when this is selected, the box pops up, prompts the user to select an employee from the list, and then runs the query with additional information about the employee. All of this works great. My question is how do I get this to work with a report? After the combo box form is run, it pulls up the data in the query format, and I can't seem to figure out or find any help on how to get this to work with reports. Any help is greatly appreciated.

Thanks!
~JP

 

[ZmrAbdulla]

[ul]
[li] Create a report with the recorsource of the query[/li]
[li] Behind the OK button you must be having code like [/li]

DoCmd.OpenQuery "QueryName" '......

change it to like

DoCmd.OpenReport "ReportName", acViewPreview '.........

[/ul]

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[JP2275]

Thanks so much! This worked perfectly.
~JP