I have several forms I want to print from (1 form at a time) to the report.
Can I use 1 report to print to for all my forms. not connected to a tbl?
Or do I have to build 1 rpt and qry for each frm ?
I have several forms I want to print from (1 form at a time) to the report.
Can I use 1 report to print to for all my forms. not connected to a tbl?
Or do I have to build 1 rpt and qry for each frm ?
What do you mean by 'print form to report'? You want the record showing on form to be printed. Report must have a RecordSource. Filter the report's RecordSource to the record displayed on the form.
Don't really know enough about your data structure but probably No, cannot use one report for all forms.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.