I have been searching for a code to run from command button to insert three text box input into a table in ms access 2007.I have created a table name table1 with three field date ,name and amount .i have found codes in tutorial sites but i cannt get it to work.can someone help me with a simple code to do it please