Simple Filter Question

[BruceJ]

I have a filter setup based on whether a time is with in a given period
based on current system time. I move through the records on a regular basis
with a userform. What will trigger the filter to re evaluate which records
to display? Sometimes it seems to adjust as the day goes by, it seems
filter, and sometimes it does not.

I have a field filled with current time, plus an adjustment for timezone

Here is the filter I am using:

Sub time4_930()
' time4_930 Macro
'Filters time periods between 4PM and 9:30PM local time

Selection.AutoFilter Field:=32, Criteria1:=">.6666", Operator:=xlAnd, _
Criteria2:="<=.875"
End Sub

Thanks
Bruce