Naiomi,

Appoplogies I chopped about the example SQL and missed out a couple of rather relevent lines, should have been:

* Move to Previous record
cSQL =	"SELECT TOP 1 * FROM "_
		& "(SELECT TOP 1 *  FROM Master WHERE " _
		& "Id < '" & cLastId & "' " _
		& "ORDER BY Id DESC) curMaster "_
	& "UNION ALL "_
	& "SELECT * FROM "_
		& "(SELECT TOP 1 * FROM Archive WHERE " _
		& "Id < '" & cLastId & "' " _
		& "ORDER BY Id DESC) curArchive "_
	& "ORDER BY Id DESC"

All the best,