Transferring Values from Form too table

[Akchayan]

Hello everyone,




I have this form:

,in this form data is entered by the user, I have a button called "cmdSave", this button should save the entered data in a table.
For example "No. 1" in the screenshot should be row 1 in the table, "No. 2" should be row 2 and so on. "1.1" should then be the first column, 1.2 the second and so on.


The table looks like this:

What would the code look like to save all this?


Thanks for your help!

[June7]

You want to limit users to entering 6 records?

This is not the best way to design a data entry form, and I think you have already been advised this in another thread.

Why do you want to do this as opposed to using a form bound to table and controls bound to fields?

Why do fields have non-informative names like 1_1?

[Welshgasman]

What would the code look like to save all this?
!

Bit of a mess I would have thought.

You would need to construct an append query for each row.
Best name the controls with 1 to six suffix so tou could use a loop.

[NoellaG]

IMO : Best way to do this is to create an object layer: for each table you want to fill in you create an object with an update/insert/delete/search method. You can than use these objects to manage your data from the forms. Objects can be created with class modules.