Sending filtered Form data to report

  • Thread starter Thread starter strive4peace
  • Start date Start date
S

strive4peace

Try using Me.Filter as the WhereCondition clause of the
OpenReport action

You can use the same filter for the report and the form IF
the controlname(s) in the form filter {is a |are}
fieldname(s) in the report recordset...

If you are getting prompted for a parameter, that is most
likely because the report definition does not contain a
specified filter field in its RecordSet.

List the fields in the report design view -->
(from the menu --> View, Fieldlist)

These are the fields in the report recordset that can be
used for filtering. Is everything you are using for a
filter available?


Warm Regards,
Crystal
Microsoft Access MVP 2006

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
I have a form based on a table (no query, just raw table) and after playing
around on the form with the filtering and sorting I want to send the results
to the Report that has the same format.
I tried to use the Me.Filter parameter in the Filter of the DoCmd.OpenReport
command but I get a parameter messagebox.
Can anyone help me with this problem. I guess it is simple but I can't find
the way of doing it.
 

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

Filtering subreports on main report 0
Report filter question 1
Filtering Report Data 3
Filter report in VBA loop not working 4
Show a report filtered by text fields of a form 5
Possible to clone a reports recordset? 9
filtered form data only 2
Select Report Fields based on filtered form 0

Back
Top