FIlter n Reports

[Wuddle]

Thanks to all for their help on my previous problem. I now have another!
I have created a query with 20 fields. From this query I have created a form. The form allows people to use filters to find specific data. The reason for using this system is because the questions vary depending on what information is required from the data. When the filter is completed I want to create a report showing just the filtered information. How can I do this?

 

[Corticus]

Hi!

I believe what you need is a select query. Instead of using filters, look at your query in design view, and find the field for criteria.
Create a form, and insert a drop-combo, or whatever, for the different values by which you would filter the data. Then, from the query, right-click on the criteria field under the field by whcih you want to filter, and select 'build'. Select 'forms' and go find the name of the combobox you just added. You will probably have to save the form before you can find it.
Then, create a report using the report wizard, and link it to this query. Finally, add a button to the form, and use the wizard to have it print the report. You could also add one the preview the report, again, using the wizard. If you have more than 2 criteria by which to filter, it gets a little trickier...

HTH,

_________________<EMBED src=http://mitglied.lycos.de/corticus/sig.swf width=170 height=70>
Corticus@TheOfficeExperts.com
TheOfficeExperts.com
This message was edited by Corticus on 2003-02-10 09:22

 

[Russell Hauf]

You can do something like this:

Create a report based on the same source as the form (before it is filtered). Then you can put a button on the form, and call the report from there something like this:<pre>Private Sub cmdOpenRpt_Click()
DoCmd.OpenReport "rpt021003", acViewPreview, , Me.Filter
End Sub</pre>
The key part is passing "Me.Filter" as the WhereCondition of the OpenReport method.

HTH,

Russell
This message was edited by Russell Hauf on 2003-02-10 13:16

 

[Wuddle]

Thanks to you both. You may have saved my life....or career....or both!!

 

[kart_deBlonch]

I have tried using Corticus' method for printing one record from a form that is set-up to display one record based on the selection from a combo box but I keep getting the every pesky “Enter Parameter Value” error message box. I have tried to set the criteria by manually entering the form and name of the combo box that is used to select the record and by using the “build” method. The field that my combo box references is an expression: “FullName: [LastName] & ", " & [FirstName]” and the “build” method produces the following: “Forms![All Contact Data by Individual Form]![Combo1]” Any ideas as to what I am doing wrong?