I have a report generated by Crystal Reports, that's for use in third-party software outside of MS Access. I have no way to generate a list of multiple records (like Access can) using this third party software, and then filter the crystal report by a selection from the list. So I'm trying to integrate this report into Access using one of the Crystal Reports controls, and I want a combo box (or list box) on the same form as the report control to have an after update event that will update the crystal report to whatever is selected in the combo box.
My question is, can someone tell me the steps I need to take to get a Crystal Report control working on a form, and if I can use that control on the afterupdate event of something else on an Access form?
I should mention that the crystal report pulls data from SQL tables, and I think I will need to have some sort of connection string. Thanks in advance.