open and closed status

[Mavis]

HI All,

I have a form to allow the user to select status ("open"/"closed") to pull
out an report.
In my datbase, there are total of 5 status (Open, Reject, Pending, Paid and
Closed).
When the user select "Open" in the form, it will pull out all record with
the status Open, Reject, Pending and paid.
When the user select "Closed" in the form, It will only pull out record with
"Closed" status only.
Can anyone advice how can i do so?
Thanks in advance.

 

[Larry Linson]

Not enough information. Selecting a value in a form (List Box? Combo Box?)
will not "pull records" so there must be more to it. If you'd go into the
detail, then someone here might well be able to make a useful suggestion.

Larry Linson
Microsoft Office Access MVP

 

[Mavis]

HI,

The user wil select the "Open" and "Closed" status using a list box. When
they select "Open" then all reocrd with status Open, Reject, Pending, Paid
will be present in the report.
If the user select the "Closed" status then only records with the "Closed"
status will be present in the report.

 

[John Spencer]

So what are you using to filter the result? Are you modifying a query,
using a filter argument, using a parameter in the query?

If you are using a parameter in the query
Forms!FormName!NameOfListbox
then you can modify the criteria for Status field to
Status = Forms!FormName!NameOfListbox or
(Status <> "Closed" and Forms!FormName!NameOfListbox <> "Closed")

If you are passing a filter via some vba then you need to modify the filter.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[reply to open my files i lose]

HI All,

I have a form to allow the user to select status ("open"/"closed") to pull
out an report.
In my datbase, there are total of 5 status (Open, Reject, Pending, Paid and
Closed).
When the user select "Open" in the form, it will pull out all record with
the status Open, Reject, Pending and paid.
When the user select "Closed" in the form, It will only pull out record with
"Closed" status only.
Can anyone advice how can i do so?
Thanks in advance.