Running a Report from combo box form

[Johnrg]

Guys,

I have a report shows historical order information from our customers thats data source is a query I designed based on two linked tables called OrdersHistory and OrdersHistoryDetails.

The query and report run fine and show the data I need however it shows all the data for all customers and I want to filter this to just show the data from the customer I choose.

I already have a from that we use to look up individual orders that uses combo boxes and one of these is a customer name feild. I want it to run of this form so I basically choose the customer from the combo box and hit the report button to show all orders.

I think I need some code in the form or report command button to only show the data for the selected customer but no idea what.

Can anyone help?

Thanks

JohnG

 

[pbaldy]

This technique with OpenReport should work:

http://www.baldyweb.com/wherecondition.htm