print macro to filter search form



Hi all,
I have a search form that finds results by filtering the original
table. It is adapted from http://allenbrowne.com/ser-62.html . All
my search boxes are text boxes on my version. I need to be able to
print the records that the search retrieves. The form is a continuous
form. I know how to set up a print macro if searching with a Query,
but I have many criterion to search for and the filter was the best
choice. Additionally I am having problems with the Query code
itself. Anyways, Is there any way to print out a report of filtered
results like that? Thank you for your time in advance.
M

.



Relevant Pages

  • RE: Trouble generating Filter for emailing report...
    ... I ended up filtering on the query as you said, ... will not filter a report. ... Static myCallID As Variant ...
    (microsoft.public.access.formscoding)
  • RE: Update Query - Automatically Store Todays Date
    ... Dim strMsg As String ... The pop up message boxes work fine, the messgaes appeared as the report ... should not contain any filtering regarding the date. ... Allen Browne's Client Search form uses the form FilterOn property to ...
    (microsoft.public.access.queries)
  • Re: Managing the flow of forms...
    ... One main modal form, which serves as what the user sees when no forms are ... >> ElseIf TypeOf objMe Is Report Then ... >> interface the reports if that uses combos to offer filtering options), ... >> Public Function OpenTheReport(strDoc As String, ...
    (microsoft.public.access.forms)
  • RE: Update Query - Automatically Store Todays Date
    ... The record source for the report ... should not contain any filtering regarding the date. ... the same filtering criteria as your form. ... records with a date (As the search form is not just for printing reports). ...
    (microsoft.public.access.queries)
  • Re: Report Form Design
    ... I place as much filtering in the where clause of the DoCmd.OpenReport method ... Dim strWhere as String ... My more sophisticated applications have report system tables for "reports", ...
    (microsoft.public.access.tablesdbdesign)