Saving multiple values in a form to a table

[mxp346]

I have a form where there are three fields that go together. There are also several sets of those three fields on the form. Is it possible to have a button that if pushed enters each set into a table whith each one having an autonumber entered with it. The setup of the form is below.

-----------------------------------
ID Description Category

ID Description Category

ID Description Category


------------
|Update Table|
------------
------------------------------------

 

[rajeessh]

If what u say is an unbound subform or a set of text boxes

When u push the button u can colkect the values in the table
and perform a insert for the fields other than AutoNumber.

Else in Form_Current keep in Id the next Max Number(May not sound good for Multiuser Purposes)