Solved

Report Filter from Form Filter

Posted on 2012-03-18
2
303 Views
Last Modified: 2012-08-13
Hi All

How do I get a report based on data in a continuous form to use the same filter currently used in the form.

The current form is filtered by the A-Z  Z-A on tool bar
0
Comment
Question by:DatabaseDek
2 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 37735234
You can read Form's property:
Me.OrderBy
and apply it to report
Check also Me.OrderByOn (true - enabled, false - disabled)
0
 

Author Closing Comment

by:DatabaseDek
ID: 37735517
Brilliant

Thank you.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question