Hi,
I saw the LimitList form in the Solutions database that come with Access. I would like to create something similar in my database.

I copied the form but am having problems with the duplication. Is there any way to see the underlying tables in the Solutions database?

I have a database of several hundred activities. About 50 of those activities have reports related to them. These reports may be required on a daily, weekly, bi-weekly, monthly, quarterly or annual basis.

In my tables I have a separate field for daily, weekly etc, with a yes/no option.

I would like my LimitList form to have the frequency listed on the left, and if the user clicks on daily, they would see all the activities (reports) that are required on a daily basis on the right. From reading the help feature "Limit the contents of a list based on the value selected in an option group" It refers to creating a query. From looking at the information given, I would want to replace CategoryID with Frequency. However I don't have a frequency field in any of my tables. I have seperate fields for Daily, Weekly etc. Do I have to create a new table or query with a frequency field in order to make this work? I tried putting in criteria "Daily"=Yes or "Weekly"=Yes etc, but that just returned all the record.

Any help would be greatly appreciated. Thanks.

just thought I'd let you know I found out how to view the underlying table, queries forms etc.

Select VIEW, TOOLBARS, CUSTOMIZE

then you will see ALL TABLES, ALL QUERIES etc