produce a report - using a drop down list

[ardagh]

My aim is to produce a report - using a drop down list (of customers from customer table) so that users can look at customer history.

I have created a form with a drop down list of customers - from customers table. I have used this to filter the results for a query on the orders table (gives me a history of that customer). All this works perfectly. I get all the transactions for that customer.

My question - is there a way I can create the same result but in a report format instead of the datasheet format.

 

[Crowley16]

presumably, you're currently using a subQuery to show the history at the moment right...

Unfortunately, you can't include a subreport on a form (at least not as far as I'm aware, but please correct me if I'm wrong)...

So you'd have to create a subform that *looks* like a report...

Personally, I'd use a listbox to display the results, since that looks close enough to be a report, especially if you set the borders and stuff, but you can't have any other formatting inside the listbox other than rows of data...

--------------------
Procrastinate Now!