AA Arens wrote:
How to perform the filtering?
pi********@hotmail.com wrote:
>>AA Arens wrote:
>>>I amde a helpdesk database and on the calls form I put record
navigation buttons
[<<] / [<] / [>] / [>>] / [New] / [Delete] / [Exit form]
Is het possible to navigate [<] / [>] through the records with a
certain status.
Each call has a certain status with is set via an Option Group and
filled in the Status colomn in the Calls table.
Bart
Acc 2003.
yes, filter the form before navigating.
You could have a combo box of status's. In the AfterUpdate event you
could have a statement like the following. I'll assume the status value
is a string, not a number
Me.Filter = "Status = '" & Me.ComboStatus & "'"
Me.FilterOn = True
It would be nice to have a status that is for displaying all Records.
Let's say you have a table of status codes. You could have a statement
similar to this
Select StatusCode, StatusDescription from Status Codes
UNION
Select "0", "All" From Status Codes
Then your filter statement might be something like
If Me.ComboStatus <"0" Then
Me.Filter = "Status = '" & Me.ComboStatus & "'"
Else
Me.Filter = ""
Endif
Me.FilterOn = (Me.ComboStatus = "0")
Me.FilterOn = True