Hi i have a form in access. on that form it has two fields with different Times.
I want access in VBA to lookup in a table all the records that fall between the two times.
This returns a debug fault
Dim newvar As Variant
newvar = DLookup("[Time]", "tblBooked", "[Time] Between [txtNOW] And [txtNOWplusONE]")