Saving Data to 5 tables from one form

[byulogia@gmail.com]

I have 5 tables. I have a form, that has all the fields from the table, What i want is, when pressing enter, the data is inserted into the tables with all fields from the form. Please give me an example code, so I can modify and use. Thanks

[June7]

This is not customary design. Will require code that runs 5 INSERT action SQL statements. Examples of INSERT action are everywhere.

Why aren't you using form/subforms arrangement? What are relationships of these 5 tables?

[CJ_London]

with a proper design you can use subforms - no code required