Form fields

[filo77]

I have a form with 10 fields and I need to store the data from those fields in a separate table. Is it possible to create a macro or a procedure that copies the data from the fields and stores the data in a table that is not directly linked, or not linked at all to the form in place??

Sounds confusing, a!?!


Thanks!

 

[smercer]

Why not just have a subform?

to make a subform, drag the table you want into the form and then name it. Make sure you have no spaces in the name.