FormFilter > ReportFilter

[Filips Benoit]

Dear All,

Form.source and report.source is the same table.
Form has serveral comboboxes hiding the Foreign keys.
Commandbutton in form to print the formselection using Form.filter as
Report.filter triggers error
when filtering on comboboxes that are not shown in the report.

How can I sove this??

Filip

[Rog]

Re: FormFilter > ReportFilter

Don't use the form's recordsource for your report. Instead, create a
query, based on the table, with conditions similar to
Forms!formname! comboname, and use that as the report's record source.

[Filips Benoit]

Re: FormFilter > ReportFilter

Thanks,

But, the client wants to make his own selections indipendently and can't
make queries himselve.

Filip

"Rog" <delahayerc@sta te.gov> wrote in message
news:1112621652 .936523.71340@z 14g2000cwz.goog legroups.com...[color=blue]
> Don't use the form's recordsource for your report. Instead, create a
> query, based on the table, with conditions similar to
> Forms!formname! comboname, and use that as the report's record source.
>[/color]