how to save record to another table in the same ms access database

• • Reply

  12 years ago

  by genius_supreme

  genius_supreme

  , Malaysia

  Joined 18 years ago

  im try to save certain fields from a table to another table. its l ike this:

  i have a form (created from table1) , once click on save button, textbox1,textbox2 value will be save in another table called table2 in the field 2 & 3 (table2 contains 3 fields but i only want to enter the 2nd & 3rd field)

  so how do i do this... any help .... with sample code appreciated

  Report abuse
• • Reply

  12 years ago

  by konikula

  Matej Kasper

  Trutnov, Czech Republic

  Joined 15 years ago

  Maybe using of Insert Into table2 (Select 0 As id, col1, col2 From table1 where ???) would help

  Report abuse