Hi Richard

I'm unsure if the comments I posted actually reached you from the online theatre screen - I am having a problem with the way access is processing my dates.  I live in New Zealand, our date format here is dd/mm/yy - so when building the scheduleF, I've used that format, however, when I come to the lesson on filtering dates, my filters return no results.  I had a similar issue when doing the expert series...Sam Finlay replied to my query then saying that he had had a similar problem using non US regional settings.  He said I need to enclose dates with a US Format.  Is this the right way to address the issue in vba? and if so, can I put a 'global' line of code that will apply the format code anytime I'm using dates?

This is the filter I've created, which is returning no results:

Private Sub BeginDateTime_AfterUpdate()

    If Hour(BeginDateTime) = 0 And Minute(BeginDateTime) = 0 Then
        BeginDateTime = BeginDateTime + (9 / 24)
    End If
    
    ' check for conflicting appointments
    Dim ID As Long
    On Error Resume Next
    ID = 0
    ID = Nz(DLookup("ScheduleID", "ScheduleT", "WorkerID=" & WorkerCombo & " AND " & _
        "BeginDateTime < #" & BeginDateTime & "# AND " & _
        "EndDate Time > #" & EndDateTime & "#"), 0)
        If ID <> 0 Then
        'we have a conflict!
        MsgBox "CONFLICT!"
    End If
      
      
    If IsNull(EndDateTime) Then
        EndDateTime = BeginDateTime + (1 / 24)
    End If

Same issue with EndDateTime

Thanks
Lynda