Generating a Report based on checked Values

[d1trupinoy]

Hi I'm a newbie to VBA and Access.

I want to build a form where I can check status values like "Not Designed", "Designed", and "Changed". Based on what words I checked I would like to generate a report to list the items that have these status values (e.g. ObjectStatus = Not Designed, Designed, or Changed)

So if I check "Designed" and click a button, a report will just show the objects that have a status of "Designed". How can I do this? I would like to use VBA because eventually I will want a report with many subreports that post all the data based on multiple status fields of items.

Thanks

 

[pcdaveh]

Build those values into your table(s) and query. Write your query and test using those values. Usually they will be either 0 for off or -1 for on, or possibly yes no fields. Build your form with your check boxes. Include a button to run the report. Now in the criteria section of your query your going to need to reference the check box. Place something to this effect in your criteria of that field [Forms]![MyFormName]![MyCheckBox] = -1 What you are building is called a parameter query. You may want to look up that term either in help or on the internet to give you somemore ideas.