Saving form data in different table

[Prashantsd]

Hi,

I just wanted to know if it is possible to save the form data into different table.

The combox box list are from the different tables and want save in another new table.
What are the settings I have to make inorder to save the data selected from combo box and result stored in text box in one table.

Thanks
Prash

[Rabbit]

There are no settings for this, you'll have to do it through code. If you wish to proceed, we need to know more about the tables.

[NeoPa]

You can do it in one of two ways :

1. Make sure the form is bound to the table you need to write the data back to. Set up your ComboBoxes and TextBoxes to get their data from external sources. This is fine for the ComboBoxes but the TextBoxes will need to be set up by code.
2. Leave the form as it is and add a 'Save' button of some form which will garner all the information required then add the data as a new record into the destination table. This can be done either with a SQL Append query or with Recordset processing code.