Hi,

I am banging my head trying to figure this out. I want to create a form similar to the Northwind Sales Report Dialog.

On that form, there is a subform that allows you to select the categories of Sales you are interested in. If you just click the Sales by Category, the resulting report shows all seperate pages for every category. However if you click a specific category from the listbox, you only get the report for that specific category.

I've tried copying the form and replacing it with my own details, but nothing seems to work. I'm wondering if I've made an error in how I setup my tables.

In my database I have numerous activities. Some of those activities are related to channels (IVR, Internet & PAT). I do have one table called TYPETABLE which lists a field called Channels and lists the 3 seperate types in different rows. Most of my other tables are related to the activities. In my ChannelTable I have the activities, plus 3 fields (IVR, Internet & PAT)that are YES/NO datatypes. Occasionally some activites will have a Yes in more than one channel. I can produce a report showing all the activities that incorporate any of the 3 channels. I can also show a report that only incorporates one of the channels.

What I can't seem to be able to do is to create a Channel Report Dialog that when I click on Channel Report will show the report reflecting all 3 channels, and then if I highlight a selection from a list box, show a report for just that channel.


I can't seem to get the listbox properties right. However I'm beginning to think I've made a mistake in the setup of my tables or queries.

Any suggestions as to where I;ve gone wrong would be appreciated.

Thanks.