recreated my file, seems to work now :)might be hardware or software though, i am now using a new platform.By the way, just a general query, when coding or coding general in notepad (Platform migration: Dreamweaver----> Notepad not good ). If i do the following to a piece of code will there be any difference?
sql="SELECT Subcode, DateGiven, DateDue, Information FROM " & tblname & " Order BY " & sort & " " & ordering & ""
typed in one complete line (notepad expands horizontally forever)or If i press enter to shift the various parts code to a new line eg.
sql="SELECT Subcode, DateGiven, DateDue, Information FROM " & tblname & " Order BY " & sort & " " & ordering & ""
will this affect the code? because i recall doing that before and it seems to cause a lot of funny errors, i didn't do it now and it seems alright