Moving records between subforms

[Frenchmarc]

Hi all,

I have a form that has 2 subforms. B clicking a button, I want to move a record from the top sub form to the bottom sub form. Also, the form needs to hold the total of a value.

This is for a stock control DB.

the form shows an account code, the top sub form shows the records of transactions attached to the account, the bottom sub form is for the records chosen, that have a "reconciled" field turned from false to true. A field on the main form adds the value in a field called " amount" in all the records.

Any ideas?

 

[Frenchmarc]

thank you , that is a great help.

So what code do I put somewhere to move the record. What is the most elegant way?