Sorry but I am totally new to all of this.

I have been asked to amend an Access 2003 database (based on Microsofts Issue logging database) so that we can search by all current jobs. At the moment we can search for all jobs (showall) or specific ones (exact match). How can I ask that if the search status criteria is "Current" show all records except those with a "Finished" status?

The current script is shown below:

'If Status
If Nz(Me.Status) = "All" Then
'Add it to the predicate - showall
Else
'Add it to the predicate - exact match
strWhere = strWhere & " AND " & "Issues.Status = '" & Me.Status & "'"
End If

Hope this makes sense.