open and closed status

  • Thread starter Thread starter Mavis
  • Start date Start date
M

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.
 
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
 
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
 
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.
 
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.
 
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
'====================================================
 
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
'====================================================
 
Mavis said:
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.
Click to expand...
 
Mavis said:
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.
Click to expand...
 
Back
Top