Thanks to everyone who suggested a solution. Think I've cracked it. Needed a call to SQL to get the correct record in the first place.
blnFound = False
strSQL = "SELECT [BOOKING REF], end_odo, start_odo, status, total_days_hired, hire_cost, sys_date_returned " & _...