Use form results to populate report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning,

I am trying to figure out how to 'tranfer' the records displayed on a form
(user control filter parameters) to populate a report so that they can get a
hardcopy of th reaults.

So far I only managed to get the first record in the report and I need all
of the records?!

Thank you for the help,

Daniel
 
Use the Where arguement of the OpenReport method. Set the Where criteria to
be the same as the currently selected filter of the form.

Docmd.OpenReport "SomeReport", , , Me.Filter
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting records shown in a report 3
Adding Blank Lines to a Report 0
Populate unbound controls on report using VBA 16
Using filtered form data as record source for report 3
Auto Populated fields from a form 2
Using Data from a Report in a Form 4
main table not populating 1
Moving data from a report to a form 4

Back
Top