I have a table and a form for it.:rolleyes: ID, customer name, date, amount ! I want the total to date amount for that costumer to show up on the form when filling up a new record for it. I'm a begginer!:) thx