Form to Report Major Problems...

[robbo5000]

I have a database with over 100 fields. I have made the form which users can filter using the Filter by Form function.

The problem is, I want to create a report based only on the filtered records and for it to NOT include all the fields in the form/database. I have tried using the "me.filter" when calling the report through a button but I get "Enter Parameter Value" box when the user filters a field that is not included in the report.

Any help will be superb.

 

[dcobau]

How do you filter the form? through a query? if this is the case, use the same query as the basis for your report then have a button of the form to lauch said report. If the filter of your form is not a query then I would create a new query.

Dave

 

[robbo5000]

No, it's filtered using the filterbyform in the form. The form connects directly to the table.

 

[robbo5000]

Any ideas anyone???