It's working! Thank you all for your input I really really appreciate it :)
On your suggestions I re-created the TBL_transaction, not with a composite index just with a normal Auto-Number field, called trans_ROW_ID. Then used the trans_row_ID in the where clause and it works perfectly. I also...