Ok, as far as I get it - you think that tblTransactions.recID == tblTransactions.transaction_Record ?
See PushButton3.Action
...
aRec = aCursor.ULongField( "Transaction_Record" ).Value
...
myDatabase.mTransaction.Change( _
myDatabase, _
aRec, _
...
myDatabase.mTransaction.Change(
inDatabase as DB_Data, inRec As Integer, inTransactionType As Integer, inCustomType As string, inDebitAccount As Integer, inCreditAccount As Integer, inAmount As Double, inComment As String, inDay As Integer )
...
If isValid( inRec ) then
...
isValid(inRec As Integer)
...
If RecordExists( inRec ) then
...