Re: Use a form to query a report

From your response, I suspect you might not have a lot of experience with
Access. So... I'd like you to reconsider my previous solution... as being a
bit easier to understand and implement.
If you don't feel your users will be able to handle "Filtering by form"
or "Filtering by selection" then Bruce's suggestion would be the best
choice.

1. My method allows the user to use the "Filter by Form" or "Filter by
Selection" function to decide what records will be delivered to the report.
If you filter for City, the report will be filtered for City. If you filter
by City AND State... the report will filtered for City AND State.
2. No need to build a seperate form to define Parameters for the report
query.
3. Instead of just 6 parameters, you can filter your form by as many
factors as necessary.
4. If your form is NOT filtered, the report returns just the "active
displayed" record.
4. It's quick and simple to understand and implement.

Use the normal form that you use to view your records (RecordSource = All
Records)

Create your form and use the same RecordSource as your form (RecordSource =
All Records)

Place this code in the Open event of your report... (using your form
name)
Private Sub Report_Open(Cancel As Integer)
If Forms!YourFormName.FilterOn = False Then
Me.Filter = "CustID = Forms!frmYourFormName!CustID"
Me.FilterOn = True
Else
Me.Filter = Forms!frmYourFormName.Filter
Me.FilterOn = True
End If
End Sub

hth
Al Camp

"Randy" <ranmcc@xxxxxxx> wrote in message
news:1117656696.207136.140500@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I am not real clear on the section below.
>
> In the parameter query (design view) set the parameter to:
> LIKE Forms!frmFind!txtDOB
> OR Forms!frmFind!txtDOB Is Null
> for each field (using the appropriate control name from frmFind). This
> will
> work for maybe 5 or 6 criteria. If you need to do more than that you
> may
> need another approach, but since you have not been specific I will
> leave it "
>
> I do have six fields I would like to put on the form. When I create
> the unbound form and then the unbound text fields I can click open the
> properties and then click on the event procedure and it will bring me
> up to a query, but all the fields in the column are blank. What do I
> need to do from here to complete the parameter query according to your
> instructions. This is where I am getting stuck.
>


.

Relevant Pages

  • Re: parameter query
    ... You could get the report you want by building a WhereCondition string to ... Use a multi-select list box to filter a report ... parameter query that displays many child records of one parent record ... I can't see how this could be done via a parameter query. ...
    (microsoft.public.access.queries)
  • Re: parameter query
    ... You could get the report you want by building a WhereCondition string to filter the report. ... parameter query that displays many child records of one parent record ... I can't see how this could be done via a parameter query. ...
    (microsoft.public.access.queries)
  • Count Items in a report
    ... I have a parameter query to filter by date from which I run a report. ... error type appears after the report is run from the query. ...
    (comp.databases.ms-access)
  • Report Filtering
    ... I have created a main report with 4 subreports. ... I have used the ApplyFilter macro action to filter the main and subreports. ... When I run the parameter query by itself, ...
    (microsoft.public.access.reports)
  • Re: Filter for Report not working?????
    ... Do I need to release the filter or close the TableFame? ... contFilter DynArrayString ... Your first example based on ContractNo ... I decided to go with a table in PRIV for the report. ...
    (comp.databases.paradox)