Set adrs3 = curdb.OpenRecordset("Select * from [SchedulingDetails] where [Date] = #" & [Forms]![SchedulingDetails]![Date] & "# ORDER BY [From]", dbOpenDynaset)
If adrs.EOF = True Then
Me![From] = txtTime
Me![To] = (Me![From] + (adrs2![TimeRequired]) / 24)
Else
Do While adrs.EOF
If adrs3![From] = txtTime Or txtTime <= adrs3![From] And adrs3![To] Then
MsgBox "Time Is Scheduled, Please Try Different Time and Try Again", vbInformation, "Fodemesi"
Else
Me![From] = txtTime
Me![To] = (Me![From] + (adrs2![TimeRequired]) / 24)
End If
adrs.MoveNext
Loop
End If



Hi in above code I will let the user Enter the time in txtTime to schedule some service for scheduler program. Each service takes some amount fo time which is coming from adrs![TimeRequired]. I want to be able to go ahead and c heck in the database if txtTime +TimeRequired is already scheduled or no. I think im on right track in above code but some how im not sure how to check Between Times since i never dealt with times before. Any help will be appreciated. Thank you in advance