Creating a Loop Statement comparing a time entered to a previous time range in the recordset

[LGrossman]

Thanks for getting back to me, I tried the suggestion below but still no joy, I actually get a Type Mismatch Error now. I dimensioned AppDate as a Double and as Date just in case that was the problem.

I also tried dd/mm/yyyy as that is my region but still no luck.

The 12th was the date and not month

This is what I did: -

AppDate = "#" & Format(Me.AppointmentDateTxt, "mm\/dd\/yyyy") & "#"

strSql = "SELECT AppointmentDate, AppStartTime, AppEndTime FROM AppointmentTbl WHERE AppointmentDate = " & AppDate

Cheers

[LGrossman]

Sorry, just realised that I used Double and not Variant as the data type. It actually works now.

Thanks once again.

[Micron]

Just got back - glad to see you solved it.