halem2
Registered User.
- Local time
- Today, 01:18
- Joined
- Nov 8, 2006
- Messages
- 180
Hi All:
running Access 2003.
I have a form called Orders and a subform in it called Order Details. In the Order Details subform there is a yes\no field for Received items.
THE FILTER DOES NOT WORK. IT'S LIKE IS NOT EVEN THERE.
I have an unbound box and in the "On Change" Event I have the following
[forms]![Order Details]![Received].
Under Data "Row Source Type" I have Value List
on "Row Source" I have "All";"Received";"Pending"
then on the Macro side I have as follows:
macro name: Received: On Change
condition: [forms]![Order Details]![Received]="All" ----- ShowAllRecords
condition: [forms]![Order Details]![Received]="Received" - ApplyFilter
condition: [forms]![Order Details]![Received]="Pending" -- ApplyFilter
and lastly under the "Where Condition" for
Received I have [Received]=0
Pending I have [Received]=1
Any ideas?
thanks!
running Access 2003.
I have a form called Orders and a subform in it called Order Details. In the Order Details subform there is a yes\no field for Received items.
THE FILTER DOES NOT WORK. IT'S LIKE IS NOT EVEN THERE.
I have an unbound box and in the "On Change" Event I have the following
[forms]![Order Details]![Received].
Under Data "Row Source Type" I have Value List
on "Row Source" I have "All";"Received";"Pending"
then on the Macro side I have as follows:
macro name: Received: On Change
condition: [forms]![Order Details]![Received]="All" ----- ShowAllRecords
condition: [forms]![Order Details]![Received]="Received" - ApplyFilter
condition: [forms]![Order Details]![Received]="Pending" -- ApplyFilter
and lastly under the "Where Condition" for
Received I have [Received]=0
Pending I have [Received]=1
Any ideas?
thanks!