I am trying to develop a simple template for collecting data and creating a standard report. The data format will not change; what I set up now will remain in use. A few details will change--category names, report headers, etc.--but these can easily be changed by users.

Producing a comprehensive report of all data is simple, too. My problem is producting sub-reports; that is, a report listing only the records in a particular category (I have the categories listed in their own table; they are selected in an Options box in the main table). I have tried using "DoCmd.OpenReport" but without success.

What I need is a simple form that lets users select the category from a drop-down menu (Option box, displaying contents of same table that is used in data-entry) and then, upon clicking a Submit button, the appropriate records are presented in a report.

This has to be bullet-proof; the users won't know squat about Access, and I'll be long gone. I'm just not able to figure out the proper use of OpenReport, I think.

Thanks in advance.