[RESOLVED] Method 'Value' of Object 'Field' failed

[whythetorment]

Ive been looking and testing my code for hours and hours now and cant figure out whats wrong...
i found out it's coz of rsx!DateReturned for some reason
ive got this

Dim days as long
 
[COLOR=RoyalBlue]days = DateDiff("d", rsx!DateReturned, rsx!DateDueBack)[/COLOR]

to get rsx i use

sstr = "Select * From Copies, Video, PriceGroup, Client, HireOut " & _
            "Where Copies.CPVideoID = Video.VideoID " & _
            "AND Video.VIDPGID = PriceGroup.PGID " & _
            "AND HireOut.HRTapeID = Copies.TapeID " & _
            "AND HireOut.HRClientID = Client.ClientID " & _
            "AND HireOut.LateCharged = 'No' " & _
            "AND Client.ClientID = " & acrit1

my system date is set to dd/MM/yyyy format and in the database (access) ive set it to dd mmm yyyy hh:nn:ss.....every other query ive used involving dates and the above formats works fine, but for some reason im getting an error on this one....i have no empty fields in DateReturned, and DateReturned is only field in my entire database that is named that?

Any ideas? i get the error on the blue line