DLookUp only selecting first two records! (moved from General) (1 Viewer)

[monk_1987]

Hi Guys

I have another problem and new this was the right place to come as people have sorted out some problems for me before!

So... I have a hidden form that pops up when the main menu is opened. I have put the code below in the 'On Timer' event.

TimeReminder = DLookup("TimeReminder", "T_ToDoList", "SetReminder <=Date() AND TimeReminder <=Time() AND Done =0 AND IDStaff = Forms!F_Overall_MainMenu!IDSTaff")
If TimeReminder = Time() Then
MsgBox "blah blah"
End If

The first two records in the form work everytime the criteria is the same. But any record past the 2nd one doesn't work at all.

Any help would be really appreciated

Thanks
Rhys